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
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.Basicreturns
Table 4-93 Output Grid from MDX Example
| East | West | South | Central |
|---|---|---|---|
| 24161 | 29861 | 13238 | 38262 |