Home > OLAP Terminology > Chapter
![]() Previous |
![]() Next |
ancestor at level
In a calculation template, this option defines a range of dimension members that have the same ancestor at a specified level. For example, if the specified level is Year in a Year-Quarter-Month hierarchy, then Q1-2011 to Q4-2011 are included in one calculation (quarters in year 2011), Q1-2012 to Q4-2012 are included in another calculation (quarters in year 2012), Jan-2011 to Dec-2011 are included in a third calculation (months in 2011), and so forth. The calculation does not include any levels higher in the hierarchy than the ancestor level.
See also ancestor.