2.2.15.1 Timeline Cache

 A Timeline cache specifies the subset of Timeline source data (section 2.2.15.1.1) that is cached for display in Timeline views (section 2.2.15.2), as well as properties related to Timeline filtering (section 2.2.15). A Timeline cache is specified by the CT_TimelineCacheDefinition element ([MS-XLSX] section 2.6.112).

A Timeline cache has an associated PivotTable ([ISO/IEC29500-1:2016] section 18.10) PivotCache (section 2.2.5.2).

If the timeline source data is an OLAP data source, the sourceName attribute of the CT_TimelineCacheDefinition element specifies the key attribute name of the associated OLAP hierarchy. If the timeline source data is a native data source, the sourceName attribute of the CT_TimelineCacheDefinition element specifies the name of the associated data table column.

If the timeline is used to filter PivotTable views, the Timeline cache specifies the PivotTable views being filtered as specified in Timeline Cache Relationship to PivotTable View (section 2.2.15.1.3).