@GENMBRS
The @GENMBRS calculation function for Essbase returns dimension members of a specific generation.
This function returns all members with the specified generation number or generation name in the specified dimension.
Syntax
@GENMBRS (dimName,genName|genNum)
Parameters
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. 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 Dimension and Member Relationships.
-
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