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

1818.1.1CT_OlapSlicerCacheRange

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

Referenced by: CT_OlapSlicerCacheRanges

A complex type that specifies a collection of cached OLAP slicer items in the OLAP level specified by the ancestor CT_OlapSlicerCacheLevelData element.

Child Elements:

i: A CT_OlapSlicerCacheItem element that specifies an OLAP slicer item in the OLAP level specified by the CT_OlapSlicerCacheLevelData element that is part of this range. The number of CT_OlapSlicerCacheItem child elements MUST be greater than 0 and equal to or less than 1,000.

Attributes:

startItem: An unsignedInt ([XMLSCHEMA2] section 3.3.22) attribute that specifies the zero-based index of the OLAP member on this OLAP level for the first item in this range. The order of the OLAP slicer item is determined by the current sort order and current slicer cross filtering setting applied to all OLAP slicer items on this OLAP level. The value of the starting position MUST be 0 or MUST be a multiple of 1,000. See Slicer Items for more information.

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

1819

1820

1821

1822

1823

1824

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

1824.1.1CT_OlapSlicerCacheRanges

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

Referenced by: CT_OlapSlicerCacheLevelData

A complex type that specifies the cached OLAP slicer items for the OLAP level specified by the CT_OlapSlicerCacheLevelData element.

Child Elements:

range: A CT_OlapSlicerCacheRange element that specifies a range of OLAP slicer items for this OLAP level within the OLAP hierarchy specified by this slicer cache.

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

1825

1826

1827

1828

1829

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

1829.1.1CT_OlapSlicerCacheLevelData

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:2012] 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:2012] 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] 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] section 2.1) fragment specifies the contents of this complex type.

1830

1831

1832

1833

1834

1835

1836

1837

1838

1839

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

1839.1.1CT_OlapSlicerCacheLevelsData

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

Referenced by: CT_OlapSlicerCache

A complex type that specifies a list of OLAP levels of the OLAP hierarchy specified by this slicer cache.

Child Elements:

level: A CT_OlapSlicerCacheLevelData element that specifies properties of an OLAP level in the OLAP hierarchy specified by this slicer cache.

Attributes:

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

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

1840

1841

1842

1843

1844

1845

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