When a Dimension’s storage mode is set to ROLAP the following settings have to be made to the levels in the dimension.
- The lowest level’s Member Keys Unique property is to be set to TRUE.
- The dimension must not contain member groups.
- If the dimension is a private one, its Aggregation Usage property must be set to Standard.
- If the dimension is a shared one, the Aggregation Usage property must be set to Standard, or Top Level Only or Bottom level only or Top and Bottom Levels(if All Level property is YES).
- Any changes in the source table requires a reprocessing of the dimension.
Virtual and parent-child dimensions always have a MOLAP storage mode.
Level naming Template and Level Naming Dialog Box
The Level Naming dialog box is displayed only for the Parent child dimensions. This dialog box appears when the user selects a level in a parent child dimension and in the Advanced Tab of the properties box selects Level Naming Template and clicks on the ellipsis.
There are a large number of properties which are supported by the level interface. A few properties that are commonly used are listed below:
- AreMemberKeysUnique property indicates whether the members of a level are uniquely identified by their member key column.
- AreMemberNamesUnique property indicates whether the members of a level are uniquely identified by their member name column.
- ColumnSize defines the size of the members in the level member key column.
- ColumnType defines the data type of the level member key column in an aggregation table.
- Description is the description of the level.
- EnableAggregations determines whether aggregations can be created for a level in a dimension whose AggregationUsage property is set to dimAggUsageColumn.
- EstimatedSize details the estimated number of members in a level.
- FromClause is the SQL FROM clause for a level.
- IsDisabled indicates whether a level is disabled.
- IsValid indicates whether a level is valid.
- IsVisible indicates whether the level is visible to Client applications.
- JoinClause is the SQL JOIN clause for the level.
- LevelNamingTemplate defines how levels are named in a Parent Child hierarchy.
- LevelType returns the enumeration constant that identifies the specific type of level.
- Name is the name of the level.
- Ordering specifies how the level should be ordered.
- OrdinalPosition returns the ordinal position of the level in the collection of levels.
- SkippedLevelColumn identifies the column that holds the number of empty levels between a member and its parent in a parent child hierarchy.
- SliceValue is the name of the level member used to define a partition slice.