Sql-server – SSAS where are olap cubes stored

olapsql-server-2008ssas

Getting started on creating data cubes with SSAS. I understand the various types of OLAP options ROLAP, HOLAP and MOLAP. However, when creating a data cube using SSAS (at least for 2008 version) I do not see where we choose this option. Would it be during the install of the server?

Where is the data stored when a data cube is created?

Best Answer

Dimensions in Microsoft SQL Server Analysis Services support either ROLAP or MOLAP.

Open the dimension in BIDS 2008, select the root dimension node

enter image description here

and change this in the properties window.

enter image description here

For fact data you open the cube and can similarly set the storage mode by selecting a measure group and altering the storage mode to one of HOLAP/ROLAP/MOLAP in its properties window.

enter image description here

But this only sets the default for new partitions. You still need to go onto the partitions tab of the cube designer and set any existing partitions to the desired configuration.