2.6.112 CT_TimelineCacheDefinition

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2010/11/main

Referenced by: timelineCacheDefinition

A complex type that specifies a Timeline cache.

Child Elements:

pivotTables: A CT_TimelineCachePivotTables element (section 2.6.113) that specifies a group of CT_ TimelineCachePivotTable elements (section 2.6.114) that specify the PivotTable ([ISO/IEC29500-1:2016] section 18.10) views and Non-Worksheet PivotTables that are filtered by the Timeline cache (section 2.1.7).

state: A CT_TimelineState element (section 2.6.116) that specifies the information used for display in the Timeline view (section 2.3.5.2).

timelinePivotFilter: A CT_TimelinePivotFilter element (section 2.6.118) that specifies the filter used by the Timeline Cache (section 2.1.7) to filter PivotTable ([ISO/IEC29500-1:2016] section 18.10) views and Non-Worksheet PivotTables. This element MUST exist only if the filterType attribute of the CT_TimelineState (section 2.6.116) element of the Timeline Cache has a value that is not one of the following:

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

Attributes:

name: An ST_Xstring ([ISO/IEC29500-1:2016] section 22.9.2.19) attribute that specifies the name of the Timeline cache (section 2.3.5.1). MUST adhere to the name production rule provided in section 2.2.2. MUST be a unique case-insensitive name within the scope of defined names.

xr10:uid: An ST_Guid ([ISO/IEC29500-1:2016] section 22.9.2.4) attribute that specifies the unique id of the Timeline cache (section 2.3.5.1).  If any instance of this type specifies this attribute, then all instances MUST specify it, and the values MUST be distinct

sourceName: An ST_Xstring attribute that specifies the MDX unique name of the key attribute of the associated OLAP hierarchy if the Timeline source data (section 2.3.5.1.1) is an OLAP data source.

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

 <xsd:complexType name="CT_TimelineCacheDefinition">
   <xsd:sequence>
     <xsd:element name="pivotTables" type="CT_TimelineCachePivotTables" minOccurs="0" maxOccurs="1"/>
     <xsd:element name="state" type="CT_TimelineState" minOccurs="1" maxOccurs="1"/>
     <xsd:element name="timelinePivotFilter" minOccurs="0" maxOccurs="1" type="CT_TimelinePivotFilter"/>
     <xsd:element name="extLst" type="x:CT_ExtensionList" minOccurs="0" maxOccurs="1"/>
   </xsd:sequence>
   <xsd:attribute name="name" type="x:ST_Xstring" use="required"/>
   <xsd:attribute ref="xr10:uid" use="optional"/>
   <xsd:attribute name="sourceName" type="x:ST_Xstring" use="required"/>
 </xsd:complexType>

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