Is there a way to rename an Analysis Services database? Can I do it through
the Analysis Manager interface?
Thanks!

I am running Sql Server 2000 Enterprise on a Windows 2003
server with Analysis Services. Everything works good but AS had a long
time to log in. I've instaled SP3a on the server and workstation. I
have IBM Datacenter with 16 CPU and 64 GB RAM and GB-LAN. What should I

For some reason, I am unable to test roles I have defined in my cubes. I have
done this before, but now the Test Role button is not appearing in the Role
Manager. Anyone have any ideas?
Thanks

I have an ODS system and a Data warehouse system
I have a Sales fact table in the ODS system and I have these fields:
SALES
ID_CUSTOMER (PK),

Would like to know how to use SQL 2000 command to modify a IDENTITY column
previously defined as YES...and now need to change it to Yes (Not For
Replication).
Thanks

Hi,
Anybony knows how much free space on disk should I have to process a new
OLAP cube?  And, if I have a processed cube and I just want to do incremental
update, how much free space on disk should I have ????

I have a customer dimension with two levels:
Master Account Num
Child Account Num
where each level has a member property called "Branch". I have a role called

I have to create a Time dimension with day grain in a Datawarehouse system
and I don’t know what is the best data type for the primary key...
For example
1) I could put Number(8) datatype, then the dates will be: 20050114,