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.

See Also

Creating Member Groups

Dimension Storage Modes

Real-Time Cubes