LEVEL
Syntax
<level-expression> := 'LEVEL(' <Key> { ',' <Integer> } ')'
Since
1.1
Return-type
Key
Description
The function returns one or more complete levels from the hierarchies of the dimension indicated with argument 1. The levels are defined by the optional arguments 2 - n. If the first argument is NULL or any level is NULL, the result is NULL. If no level is defined, an empty result is returned.´
Note: This function is not affected by the current filter, it will always return complete and unfiltered levels.
Examples
LEVEL( Time, 0 )
= Time:'Complete Period'
LEVEL( Time, 1, 2 )
= Time:'2003' + Time:'Jan/2003' + ... + Time:'Dez/2003'
LEVEL( Time )
= Empty result
LEVEL( NULL )
= NULL
LEVEL( Time, NULL )
= NULL
See also
ALL, LEVELOF
