<ST_MdxSetOrder> (MDX Set Order)

This type represents an enumeration specifying an MDX set order.

This simple type's contents are a restriction of the XML Schema string datatype.

The following are possible enumeration values for this type:

Enumeration Value

Description

<a> (Ascending)

Sort ascending.

<aa> (Alpha Ascending Sort Order)

Sorted alphabetically in ascending order by the caption.

<ad> (Alpha Descending Sort Order)

Sort in descending order alphabetically by the caption.

<d> (Descending)

Sort descending.

<na> (Natural Ascending)

Sorted in ascending order by the natural order of the data - usually by the key. For instance if there is a list of accounts in a general ledger, this may be in order of account number.

<nd> (Natural Descending)

Sorted in descending order by the natural order of the data - usually by the key. For instance if there is a list of accounts in a general ledger, this may be in order of account number.

<u> (Unsorted)

Unsorted.

Referenced By

<ms@o> (§3.9.12)

The following XML Schema fragment defines the contents of this simple type:

<simpleType name="ST_MdxSetOrder">
	<restriction base="xsd:string">
	<enumeration value="u"/>
	<enumeration value="a"/>
	<enumeration value="d"/>
	<enumeration value="aa"/>
	<enumeration value="ad"/>
	<enumeration value="na"/>
	<enumeration value="nd"/>
	</restriction>
</simpleType>