Analysis Services
Specify Storage Mode and Member Groups (Dimension Wizard)
In this step of the wizard, you can determine the storage mode for your dimension.
This step is displayed only if you selected Storage mode and member groups in the Select advanced options step of the wizard.
Options
Store as multidimensional OLAP (MOLAP)
Select to store your dimension's data on the Analysis server. This is the default option.
- Create member groups for the lowest level
Select to automatically create a grouping level if the lowest level of the dimension contains more than 64,000 members.
Store as relational OLAP (ROLAP)
Select to optimize query performance for extremely large dimensions, those generally having 5 million members or more. Dimension data remains in the dimension tables.
- Enable real-time updates
Select for the dimension to support real-time updates.