Share via

2.6.78 CT_OlapSlicerCacheLevelData

  • Article

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

Referenced by: CT_OlapSlicerCacheLevelsData

A complex type that specifies the properties of an OLAP level in the OLAP hierarchy specified by this slicer cache and specifies the OLAP members that are cached for this OLAP level within the OLAP hierarchy specified by this slicer cache.

Child Elements:

ranges: A CT_OlapSlicerCacheRanges element that specifies cached OLAP slicer items for the OLAP level specified by this element.

Attributes:

uniqueName: An ST_Xstring ([ISO/IEC29500-1:2016] section 22.9.2.19) attribute that specifies the MDX unique name of the OLAP level specified by this element within the OLAP hierarchy specifies with this slicer cache. The length of this string MUST be at least 1 character and MUST NOT exceed 32,767 characters.

sourceCaption: An ST_Xstring ([ISO/IEC29500-1:2016] section 22.9.2.19) attribute that specifies the caption of the OLAP level specified by this element within the OLAP hierarchy specified with this cache. The length of this string MUST NOT exceed 65,535 characters.

count: An unsignedInt ([XMLSCHEMA2/2] section 3.3.22) attribute that specifies the total number of OLAP members in the OLAP data source in this OLAP level within the OLAP hierarchy specified by this slicer cache. The default value is zero.

sortOrder: An ST_OlapSlicerCacheSortOrder attribute that specifies how the OLAP slicer items for the OLAP level specified by this element are sorted in the slicer view.

crossFilter: An ST_SlicerCacheCrossFilter attribute that specifies how the OLAP slicer items that are used in slicer cross filtering are displayed.

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

 <xsd:complexType name="CT_OlapSlicerCacheLevelData">
   <xsd:sequence>
     <xsd:element name="ranges" type="CT_OlapSlicerCacheRanges" minOccurs="0" maxOccurs="1"/>
   </xsd:sequence>
   <xsd:attribute name="uniqueName" type="x:ST_Xstring" use="required"/>
   <xsd:attribute name="sourceCaption" type="x:ST_Xstring" use="optional"/>
   <xsd:attribute name="count" type="xsd:unsignedInt" use="required"/>
   <xsd:attribute name="sortOrder" type="ST_OlapSlicerCacheSortOrder" use="optional" default="natural"/>
   <xsd:attribute name="crossFilter" type="ST_SlicerCacheCrossFilter" use="optional" default="showItemsWithDataAtTop"/>
 </xsd:complexType>

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