@LEVMBRS

Function

The @LEVMBRS() function 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. A value of 0 or a negative integer defines a level number.

Notes

• If you specify a name for the levName parameter, Hyperion Essbase looks for a level with that name in the specified dimension.
• If you specify a number for the levName parameter (for example, 2), Hyperion Essbase first looks for a level with a number string name. If no level name exists with that name, Hyperion Essbase checks to see if the parameter is a valid level number.
• If you specify a temporary variable for the levName parameter, Hyperion Essbase does not recognize the value of the variable. It looks in the outline for a level name with the same name as the temporary variable.
• For more information about levels and defining level names, see the Database Administrator's Guide.
• Hyperion Essbase sorts the generated list of members in ascending order. Using Sample Basic as an example, if you specify @LEVMBRS(Product,-1), Hyperion Essbase returns 100, 200, 300, 400, Diet (in that order). This order is important to consider when you use the @LEVMBRS member set function with certain forecasting and statistical functions.

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

Copyright (c)1991-2000 Hyperion Solutions Corporation. All rights reserved.