Returns the generation number of the current member combination for the specified dimension. This number represents the number of members separating the current member from the top-most member of the dimension.
@CURGEN (dimName)
dimName | Single dimension name specification. dimName must be the name of the top-most member of the dimension. It cannot be another member name from within the dimension. |
Inventory Opening Inventory (+) Additions (~) Ending Inventory (~)The generation value of Inventory is the same as the stored member under it, Opening Inventory. For this example, Opening Inventory is at generation 3. When Inventory is the current member @CURGEN(Measures) returns generation 3.
Given the following database structure:
Year Qtr1 Jan, Feb, Mar Qtr2 Apr, May, Jun Qtr3 Jul, Aug, Sep Qtr4 Oct, Nov, Dec
@CURGEN provides the following results for the members shown:
Formula Current Member Value Position = @CURGEN(Year); Year 1 Position = @CURGEN(Year); Qtr2 2 Position = @CURGEN(Year); Oct 3
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |