Returns all members in a dimension with the specified level name. This command does not work with Hybrid Analysis members.
Syntax
LEV name,dimension
When used as an extraction command in conjunction with the <LINK command, the syntax is:
<LEV(dimension,levNumber)
Parameter | Description |
---|---|
name | Level name |
dimension | Dimension name |
levNumber | Level number |
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.
See Also