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?

  • 2
    "I do not see where we choose this option." which option? The storage mode or the directory path? – Martin Smith Jul 8 '16 at 19:30
  • @MartinSmith The storage mode. – user275157 Jul 10 '16 at 8:25

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.

| improve this answer | |

This is where OLAP puts everything by default, but during the install I believe you can choose where you want your olap database (Data Directories tab). Look for a .db folder for your olap database in the below location, as well as supporting files (like .xml) in the OLAP folder for your olap database.

...\Program Files\Microsoft SQL Server\MSAS12.MSSQLSERVER\OLAP\Data\

| improve this answer | |
  • Is it a ROLAP, HOLAP or a MOLAP at this point? Is there a way to choose? Thanks – user275157 Jul 10 '16 at 8:21

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.