LEV

Returns all members in a dimension with the specified level name.

Syntax

LEV name,dimension

When used as an extraction command in conjunction with the <LINK command, the syntax is:

<LEV(dimension,levNumber)

Parameters

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.