Share via

2.6.74 CT_OlapSlicerCacheItem

  • Article

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

Referenced by: CT_OlapSlicerCacheRange

This element specifies an OLAP slicer item of the OLAP level in the OLAP hierarchy specified by the ancestor CT_OlapSlicerCacheLevelData element. This element contains a list of all ancestor OLAP members of this OLAP slicer item in the OLAP hierarchy.

Child Elements:

p: A CT_OlapSlicerCacheItemParent element that specifies the OLAP members that are ascendants of the OLAP slicer item specified by this element. The first element in this list specifies the OLAP member that is the parent of the OLAP slicer item specified by this element. Each subsequent element in this list specifies an ascendant OLAP member in the next level up the OLAP hierarchy.

Attributes:

n: An ST_Xstring ([ISO/IEC29500-1:2016] section 22.9.2.19) attribute that specifies the MDX unique name of the OLAP member associated with the OLAP slicer item specified by this element.

c: An ST_Xstring ([ISO/IEC29500-1:2016] section 22.9.2.19) attribute that specifies the caption of the OLAP slicer item specified by this element.

nd: A Boolean ([XMLSCHEMA2/2] section 3.2.2) attribute that specifies whether the OLAP slicer item specified by this element has no data associated with it. This attribute MUST NOT exist if the crossFilter attribute of the ancestor element CT_OlapSlicerCacheLevelData is "none". For more information, see Slicer Cross Filtering.

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

 <xsd:complexType name="CT_OlapSlicerCacheItem">
   <xsd:sequence>
     <xsd:element name="p" type="CT_OlapSlicerCacheItemParent" minOccurs="0" maxOccurs="unbounded"/>
   </xsd:sequence>
   <xsd:attribute name="n" type="x:ST_Xstring" use="required"/>
   <xsd:attribute name="c" type="x:ST_Xstring" use="optional"/>
   <xsd:attribute name="nd" type="xsd:boolean" use="optional" default="false"/>
 </xsd:complexType>

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