ANCESTORS
Syntax
<ancestors-expression> := 'ANCESTORS(' <Key> ')'
Since
1.2
Return-type
Key
Description
This function returns all keys above the argument's keys in their hierarchy (including their parents, their parent's parents and so on, and the dimension's root-key). If the argument is NULL, the return-value is also NULL.
Examples
ANCESTORS( Time:'01.07.2003' )
Returns Time:'Jul/2003' + Time:'2003' + Time:'Complete Period'
See also
CONCAT, FILTER, PARENT, PEDIGREE
