Tutorial 29: MSAS : Working with Standard Dimensions

Article Index
Tutorial 29: MSAS : Working with Standard Dimensions
Page 2
Page 3

Page 3 of 3

Steps for creating a Default Member

In the Dimension tree select the Dimension level and on the Advanced tab of the properties pane, change the Member Keys unique property to True.
In the Dimensions Tree select the Dimension, select Default Member Property, and click the ellipsis button. Select the property required and click Ok.
Select the Dimension level again(step 1) and change the Member Names Unique property to True. Then select the Dimension, select the Default Member Property, click the ellipsis button select the name and click Ok.
Select the Dimension, change the Member Keys Unique property to True and press enter. Click Yes when informed that this will change the property for all levels
Select the Default member property, click the ellipsis button, select the default value and click Ok.

Create a detail level member property

In the Dimension Editor, Click the schema tab to convert the right pane into the schema pane.
In the dimension tree, expand the Dimension level to see the member properties folder beneath it.
Drag a member property from the table onto the member properties folder. The folder expands to show you the member properties.

4. Click the data tab and expand the Default “All members” leaf and select the specified default member to see the member property (“Units Per case”) of the default member.

Ragged hierarchy:

The member names and keys of a dimension are derived from the dimension table. Each level in a standard dimension corresponds to a column in the dimension table. Under normal circumstances, each member of the dimension hierarchy has the same number of members above it as any other member at the same level. Such levels are called ‘balanced’. However, sometimes levels are not balanced. Some members will have unusual relationship with the other members. Such levels are called ragged levels. In a ragged standard dimension, a parent is hidden and the extra space is removed. Though the ragged dimension is internally balanced, the user has the impression that there are fewer members above the level.

Tags