Share via

2.7.19 ST_OlapSlicerCacheSortOrder

  • Article

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2009/9/main

Referenced by: CT_OlapSlicerCacheLevelData

A simple type that specifies how the OLAP slicer items are sorted in the slicer view.

Value

Meaning

natural

The OLAP slicer items are sorted in original order as determined by the OLAP slicer source data.

ascending

The OLAP slicer items are sorted in ascending alphabetical order.

descending

The OLAP slicer items are sorted in descending alphabetical order.

The following W3C XML Schema ([XMLSCHEMA1/2] section 2.1) fragment specifies the contents of this simple type.

 <xsd:simpleType name="ST_OlapSlicerCacheSortOrder">
   <xsd:restriction base="xsd:string">
     <xsd:enumeration value="natural"/>
     <xsd:enumeration value="ascending"/>
     <xsd:enumeration value="descending"/>
   </xsd:restriction>
 </xsd:simpleType>

See section 5.4 for the full W3C XML Schema ([XMLSCHEMA1/2] section 2.1).