@LEVMBRS

Returns all members with the specified level number or level name in the specified dimension.

Syntax

@LEVMBRS (dimName, levName|levNum)

dimName Dimension name specification.
levName|levNum A level name or an integer value that defines the number of a level. The integer value must be 0 or a positive integer.

Notes

Examples

In the Sample Basic database:

@LEVMBRS(Measures,"Profit and Loss")  
@LEVMBRS(Measures,0)
both return the following members if level 0 of the Measures dimension is named Profit and Loss:
Sales, COGS, Marketing, Payroll, Misc, Opening Inventory, Additions, Ending Inventory, Margin %, Profit %, and Profit per Ounce (in that order).
@LEVMBRS(Scenario,0)
Returns Actual, Budget, Variance, and Variance %.

The following example restricts the calculation to members with the combination Budget and one of the members of the Market dimension with a level name of "State".

FIX (Budget,@LEVMBRS(Market,State))
   CALC DIM (Year,Measures);
ENDFIX

See Also

@GENMBRS

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com