@CURGEN

The @CURGEN() function 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.

Syntax

@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.

Notes

For further discussion on generations, please refer to the Database Administrator's Guide.

Example

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

See Also

@CURLEV
@GEN