Aggregation Storage Question

Hi,

I have built a cube in which the aggregation storage is about 45
GB, the cube size is 2 GB. When I look into the data folder in the
directory where Analysis Services is installed, I just see the size of
the folder corresponding to the database as 2GB. I am not able to
understand at what location the aggragations are stored, can some one
please help on this.

Also is there a way to change the location of where the cube data is
stored, let's say I want to change the storage location to a different
drive on the server, how can I accomplish that.

Thanks

Aggregation wizard allows you to specify target size of aggregations. That doesnt mean aggregations will take that much space.
In your case looks like they didnt. Or you didnt processed your aggregations after designing them. You can ether fully reprocess your partitions or you can use ProcessIndex to process only aggregations and indexes.
Here is whitepaper talking about processing options http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/sql2k5_asprocarch.asp

Now, even after you process your aggregations, you are not guaranteed the size of real aggregations will match the estimate you saw in Aggregation Desing Wizard. The wizard only operates with estimates and not the real numbers.

As for the second question. You can change locations for partitions storage using StorageLocation property of the partition. Change it, then reprocess your partition and you see partition data located in the directory specified.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Edward,

Thanks for the response.... I now understand that the aggregations that I see in the wizard are essentially estimates however if I process them where are they physically stored, I am just trying to get to the location on the server. Also I am using Analysis Services 2000 are the aggregations stored differently from 2005 , because the article you sent me references 2005.

Thanks

|||

Aggregations are stored as part of partition storage. That is true for AS2000 and AS2005.

With AS2000 you dont have option to store partitions outside of the data folder. My previous post referred to AS2000.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.