Specify Attribute Ordering (Business Intelligence Wizard) (SSAS)

Use the Specify Attribute Ordering page to specify the ordering attributes and ordering criteria for attributes in the selected dimension.


  • Attribute
    Displays the attributes available for the dimension.
  • Ordering Attribute
    Select the attribute with which to order the corresponding Attribute. You can specify the same attribute.

    To create a new ordering attribute, select <New attribute>, and in the Select a Column dialog box, select the column on which the new attribute is to be based.

  • Criteria
    Specify the criteria from the Ordering Attribute to use to order the members in the corresponding Attribute. The following table lists the available criteria.

    Value Description


    Sort Attribute by the member names of the attribute in Ordering Attribute.


    Sort Attribute by the member keys of the attribute in Ordering Attribute.

See Also


Business Intelligence Wizard F1 Help (SSAS)
Cube Designer (SSAS)
Dimension Designer (SSAS)

Help and Information

Getting SQL Server 2005 Assistance