LEV
The Essbase Report Writer LEV command returns all members in a dimension with the specified level name.
Syntax 1
LEV name,dimension
Syntax 2
When used as an extraction command in conjunction with the <LINK command, the syntax is:
<LEV(dimension,levNumber)
Notes
-
The report script can use either default level names or user-defined level names. Examples of default level names are LEV0, LEV1, and so on.
-
Use quotes around the LEV command if the dimension name contains spaces.
Example
LEV0,Product
Selects members of level 0 from the Product dimension.
ZipCodeLev,State
Selects members of the user-defined generation name ZipCodeLev from the State dimension.
"LEV1,All Regions"
Selects members of level 1 from the All Regions dimension.
<LINK (<GEN(Market,2) AND NOT <LEV(Market,0))
Selects members of generation 2, but not level 0 from the Market dimension.