Essbase @GENMBRS

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

Syntax

@GENMBRS (dimName,genName|genNum)
Parameter Description

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, Essbase looks for a generation with that name in the specified
    dimension.

  • If you specify a number for the genName parameter
    (for example, 2), Essbase first looks for a generation
    with a number string name. If no generation name exists with that numeric
    name, 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 Essbase, generations begin numbering at 1.

  • If you specify a temporary variable for the genName parameter, 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 Oracle Essbase Database Administrator’s Guide.

  • Essbase sorts the generated list of
    members in ascending order. Using Sample Basic as an example, if you specify @GENMBRS(Product,2), 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