Where are aggregations tables stored? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Where are aggregations tables stored?

I found the following in books online Set Aggregation Options (Storage Design Wizard) Estimated storage reaches Enter the amount of hard disk storage to allocate for storing the aggregation tables. You can enter a maximum storage size in either megabytes (MB) or gigabytes (GB).
Now can anyone tell me where are aggregations tables actually stored at? Thanks
Shahab
It depends what storage mode you choose, ROLAP aggregations are stored in the RDBMS, MOLAP and HOLAP aggregations are stored on the Analysis Server in the cube map files.
Regards Raulie
]]>