2.3.5.1.2 Timeline Cache Relationship to PivotCache

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

Multiple Timeline caches can be associated with one PivotTable PivotCache.

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