Returns all members with the specified generation number or generation
name in the specified dimension.
A single dimension name specification.
Generation name or generation number from dimName.
If you specify a name for the genName parameter, Essbase looks for a generation with that name in the specified
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.
In the Sample Basic database:
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