How in Analysis Services do you order dimension attribute during design

Written by Vidas Matelis. Posted in Design FAQ

Q: How do you order dimension attribute?

A: Each attribute has following properties that defines how attribute is ordered:

Order By
Order By Attribute

Order by attribute is drop down list that contains following options:

Key
Name (default option)
Attribute Key
Attribute Name

Option "Key" means that attribute will be ordered based on key value. Do not forget that ordering depends on key type: example if key is integer, then ordering will be 1, 2, 3..., 11, 12. If Key is string, then ordering will be 1, 11, 12, 2, 3 ...

Option "Name" means that attribute will be ordered based on name value.

Option "Attribute Key" means that ordering will be based on attribute that is specified in property "Order by Attribute" key value.

Option "Attribute Name" means that ordering will be based on attribute that is specified in property "Order by Attribute" name value.

Property "Order By Attribute" lets you choose attribute for "Attribute Key" and "Attribute Name" options in "Order By" property.

Tags: design, faq