Returns all members with the specified generation number or generation name in the specified dimension.
@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. |
@GENMBRS(Product,2)
,
Analytic Services 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:
@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,
andDec
(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
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |