IsGeneration

The MDX IsGeneration function for Essbase returns TRUE if the member is in a specified generation.

Syntax

IsGeneration ( member, index )

Parameters

member

A member specification.

index

A generation number.

Example

The following expression:

IsGeneration([Market].CurrentMember, 2) 

returns TRUE if the current member of the Market dimension is at generation 2.

Therefore, the following query:

SELECT
 Filter([Market].Members, IsGeneration([Market].CurrentMember, 2))
ON COLUMNS
FROM Sample.Basic

returns the following output:

Table 4-93 Output Grid from MDX Example

East	West	South	Central
24161	29861	13238	38262

See Also

Generation

IsLevel