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