[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
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="a"/>
<enumeration value="aa"/>
<enumeration value="ad"/>
<enumeration value="na"/>
<enumeration value="nd"/>
</restriction>
</simpleType>