@ISGEN

The @ISGEN calculation function for Essbase tells whether the current member is in a specific generation.

This function returns TRUE if the current member of the specified dimension is in the specified generation.

Syntax

@ISGEN (dimName, genName | genNum)

Parameters

dimName: The name of a dimension.
genName or genNum: A generation name or a non-negative integer value that defines the number of a generation.

Example

In the Sample Basic cube:

@ISGEN(Measures,3)

Returns TRUE if the current member is Margin, Total Inventory, or Margin %, because these members are all in generation 3 of the Measures dimension.

@ISGEN(Market,2)

Returns FALSE if the current member is New York or Market, because these members are not in generation 2 of the Market dimension.