[ms-xlsx]: Excel (. xlsx) Extensions to the Office Open xml spreadsheetml file Format Intellectual Property Rights Notice for Open Specifications Documentation

1845.1.1CT_OlapSlicerCache

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

Referenced by: CT_SlicerCacheData

A complex type that specifies the associated OLAP PivotTable ([ISO/IEC29500-1:2012] section 18.10) PivotCache, and specifies OLAP Slicer Items. See Slicer Cache Relationship to PivotCache for more details.

Child Elements:

levels: A CT_OlapSlicerCacheLevelsData element that specifies a list of OLAP levels of the OLAP hierarchy specified by this slicer cache.

selections: A CT_OlapSlicerCacheSelections element that specifies a list of OLAP Slicer Items that are selected.

extLst: A CT_ExtensionList ([ISO/IEC29500-4:2012] section A.2) element that specifies future extensibility for this element.

Attributes:

pivotCacheId: An unsignedInt ([XMLSCHEMA2] section 3.3.22) attribute that specifies the associated OLAP PivotTable ([ISO/IEC29500-1:2012] section 18.10) PivotCache. MUST be equal to the pivotCacheId attribute of an existing CT_PivotCacheDefinition element.

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

1846

1847

1848

1849

1850

1851

1852

1853

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

1853.1.1CT_OlapSlicerCacheSelections

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

Referenced by: CT_OlapSlicerCache

A complex type that specifies the OLAP slicer items that are selected in the slicer cache.

Child Elements:

selection: A CT_OlapSlicerCacheSelection element that specifies an OLAP slicer item that is selected in the slicer cache.

Attributes:

count: An unsignedInt ([XMLSCHEMA2] section 3.3.22) attribute that specifies the number of selection child elements of this element.

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

1854

1855

1856

1857

1858

1859

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

1859.1.1CT_OlapSlicerCacheSelection

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

Referenced by: CT_OlapSlicerCacheSelections

A complex type that specifies an individual OLAP slicer item that is selected for filtering. This complex type also specifies the ancestor OLAP members of the OLAP member associated with the OLAP slicer item in the OLAP hierarchy.

Child Elements:

p: A CT_OlapSlicerCacheItemParent element that specifies OLAP members that are the ancestors of the OLAP member associated with 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 member associated with the OLAP slicer item specified by this element. Each subsequent element in this list specifies an ancestor OLAP member in the next level up the OLAP hierarchy, excluding the OLAP All member.

Attributes:

n: An ST_Xstring ([ISO/IEC29500-1:2012] 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.

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

1860

1861

1862

1863

1864

1865

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

1865.1.1CT_TabularSlicerCache

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

Referenced by: CT_SlicerCacheData

A complex type that specifies non-OLAP slicer items that are cached within this slicer cache and properties of the slicer cache specific to non-OLAP slicer items.

Child Elements:

items: A CT_TabularSlicerCacheItems element that specifies non-OLAP slicer items that are cached within this slicer cache.

extLst: A CT_ExtensionList ([ISO/IEC29500-4:2012] section A.2) element that specifies future extensibility for this element.

Attributes:

pivotCacheId: An unsignedInt ([XMLSCHEMA2] section 3.3.22) attribute that specifies the associated non-OLAP PivotTable ([ISO/IEC29500-1:2012] section 18.10) PivotCache. MUST match the pivotCacheId attribute of an existing CT_PivotCacheDefinition element.

sortOrder: An ST_TabularSlicerCacheSortOrder attribute that specifies how the non-OLAP slicer items are sorted in the slicer view.

customListSort: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether custom lists are used when sorting the non-OLAP slicer items.

Value	Meaning
"false"	Custom lists are not used when sorting the non-OLAP slicer items.
"true"	Custom lists are used when sorting the non-OLAP slicer items.

showMissing: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether non-OLAP slicer items that correspond to unused PivotTable ([ISO/IEC29500-1:2012] section 18.10) cache items that existed previously, but are no longer present in the PivotTable ([ISO/IEC29500-1:2012] section 18.10) source data, are displayed.

Value	Meaning
"false"	The unused non-OLAP slicer items are not displayed.
"true"	The unused non-OLAP slicer items are displayed.

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

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

1866

1867

1868

1869

1870

1871

1872

1873

1874

1875

1876

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