OrderBy Element (ASSL)

Describes how to order the members contained in the attribute.

Syntax

<DimensionAttribute>
   ...
      <OrderBy>...</OrderBy>
   ...
</DimensionAttribute>

Element Characteristics

Characteristic Description

Data type and length

String (enumeration)

Default value

Name

Cardinality

0-1: Optional element that can occur once and only once.

Element Relationships

Relationship Element

Parent element

DimensionAttribute

Child elements

None

Remarks

The value of this element is limited to one of the strings listed in the following table.

Value Description

Name

Order by the member name.

Key

Order by the member key.

AttributeKey

Order by the member key of the attribute specified in the OrderByAttributeID element of DimensionAttribute.

AttributeName

Order by the member name of the attribute specified in the OrderByAttributeID element of DimensionAttribute.

The enumeration that corresponds to the allowed values for OrderBy in the Analysis Management Objects (AMO) object model is OrderBy.

See Also

Reference

Properties (ASSL)

Help and Information

Getting SQL Server 2005 Assistance