Specify Ordering and Uniqueness (Dimension Wizard)

Analysis Services

Analysis Services

Specify Ordering and Uniqueness (Dimension Wizard)

In this step of the wizard, you can enable associated data for nonleaf dimension members, that is, dimension members with one or more descendants.

This step is displayed only if you selected Ordering and uniqueness in the Select advanced options step of the wizard. In addition, available options for this step differ for parent-child dimensions.

Options (Regular and Virtual Dimensions)

Name

View the name of the level.

Order by

Select <name> to sort by member name, <key> to sort by the member key column, or <column> to sort by the column name. If you select <column>, the Select Column dialog box is displayed.

Keys unique

Select the object that determines the scope of unique member values.

Names unique

Select the object that determines the scope of unique member names.

Options (Parent-Child Dimensions)

Order members by

Select <name> to sort by member name, <key> to sort by the member key column, or <column> to sort by the column name. If you select <column>, the Select Column dialog box is displayed.

Names are unique among

Select the object that determines the scope of unique member names.