@GENMBRS

The @GENMBRS() function returns all members with the specified generation number or generation name in the specified dimension.

Syntax

@GENMBRS(dimName,genName|genNum)

dimName A single dimension name specification.

genName|genNum Generation name or generation number from dimName. A positive integer defines a generation number.

Notes

If you specify a name for the genName parameter, Hyperion Essbase looks for a generation with that name in the specified dimension.
If you specify a number for the genName parameter (for example, 2), Hyperion Essbase first looks for a generation with a number string name. If no generation name exists with that numeric name, Hyperion Essbase checks to see if the parameter is a valid generation number. Check the application event log after running the calculation to make sure that the correct members were calculated.
Generation 0 is not a valid generation number. In Hyperion Essbase, generations begin numbering at 1.
If you specify a temporary variable for the genName parameter, Hyperion Essbase does not recognize the value of the variable. It looks in the outline for a generation name with the same name as the temporary variable.
For more information about generations and defining generation 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 @GENMBRS(Product,2), Hyperion Essbase returns 100, 200, 300, 400, Diet (in that order). This order is important to consider when you use the @GENMBRS member set function with certain forecasting and statistical functions.

Example

In the Sample Basic database:

@GENMBRS(Year,Month)
@GENMBRS(Year,3)

both return the following members since generation 3 of the Year dimension is named Month:

Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, and Dec (in that order).

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

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

See Also

@LEVMBRS

dimName	A single dimension name specification.
genName\|genNum	Generation name or generation number from dimName. A positive integer defines a generation number.