2.2.15 Timelines

A Timeline is a mechanism for filtering data in PivotTable ([ISO/IEC29500-1:2016] section 18.10) views, cube functions, and Charts ([ISO/IEC29500-1:2016] section 21.2) based on Non-Worksheet PivotTables. In the case of using OLAP Timeline source data (section 2.2.15.1.1), a Timeline is based on a key attribute of an OLAP hierarchy. In the case of using native Timeline source data (section 2.2.15.1.1), a Timeline is based on data table column.

A Timeline has two major parts a Timeline cache, and a Timeline view. There can be more than one Timeline view based on a single Timeline cache.