Share via

2.2.15.1.3 Timeline Cache Relationship to PivotTable View

  • Article

A Timeline cache can be associated with PivotTable ([ISO/IEC29500-1:2016] section 18.10) views and Charts ([ISO/IEC29500-1:2016] section 21.2) based on Non-Worksheet PivotTables, as specified by the pivotTables group element of the CT_TimelineCacheDefinition ([MS-XLSX] section 2.6.112) element.

If the associated PivotTable PivotCache of a Timeline cache, as specified by the Timeline Cache Relationship to PivotCache, is an OLAP PivotTable PivotCache, the Timeline State of the Timeline cache is used to apply PivotTable OLAP date filter to the PivotTable hierarchy which belongs to the same dimension as the hierarchy associated with the sourceName attribute of the CT_TimelineState ([MS-XLSX] section 2.6.116) element, in all associated PivotTable views and Charts based on Non-Worksheet PivotTables, of the Timeline cache. The selected date range in the Timeline cache is converted into selected PivotTable items in the PivotTable OLAP date filters by the application to apply the filter state of the Timeline cache to the associated PivotTable views and Charts based on Non-Worksheet PivotTables.

When an OLAP PivotTable view is associated with an OLAP Timeline cache (section 2.2.15.1), there MUST NOT be more than one Timeline cache (section 2.2.15.1) for each OLAP hierarchy. If the Timeline cache has at least one Chart based on Non-Worksheet PivotTables then the Timeline cache MUST be OLAP sourced. When a native PivotTable view is associated with a native Timeline cache, there MUST NOT be more than one Timeline cache for each data table column.