Share via

2.2.15.1.2 Timeline Cache Relationship to PivotCache

  • Article

A Timeline cache is associated with a PivotTable ([ISO/IEC29500-1:2016] section 18.10) PivotCache through the pivotCacheId attribute of the CT_TimelineState ([MS-XLSX] section 2.6.116) element. If the Timeline cache has an associated PivotTable ([ISO/IEC29500-1:2016] section 18.10) PivotCache, the timelineData attribute of the CT_TimelinePivotCacheDefinition ([MS-XLSX] section 2.6.109) element MUST be "true".

Multiple Timeline caches can be associated with one PivotTable ([ISO/IEC29500-1:2016] section 18.10) PivotCache.

If a Timeline cache (section 2.2.15.1) is associated, as specified by Timeline Cache Relationship to PivotTable View (section 2.2.15.1.3), with one or more PivotTable ([ISO/IEC29500-1:2016] section 18.10) views, the PivotTable ([ISO/IEC29500-1:2016] section 18.10) PivotCache that is associated with the Timeline cache (section 2.2.15.1) and all PivotTable ([ISO/IEC29500-1:2016] section 18.10) PivotCaches that are associated with the PivotTable ([ISO/IEC29500-1:2016] section 18.10) views MUST be based on the same source – an OLAP connection ([ISO/IEC29500-1:2016] section 18.13.5) if the Timeline source data (section 2.2.15.1.1) is OLAP and a data table if the Timeline source data (section 2.2.15.1.1) is native, and the PivotTable ([ISO/IEC29500-1:2016] section 18.10) PivotCaches associated with the PivotTable ([ISO/IEC29500-1:2016] section 18.10) views MUST NOT be associated with any Timeline cache (section 2.2.15.1). The timelineData attribute of the CT_TimelinePivotCacheDefinition ([MS-XLSX] section 2.6.109) element for each PivotTable ([ISO/IEC29500-1:2016] section 18.10) PivotCache associated with the PivotTable ([ISO/IEC29500-1:2016] section 18.10) views MUST be "false".