Returns TRUE if the member is in a specified generation.
IsGeneration ( member, index )
| member | A member specification. |
| index | A generation number. |
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
| East | West | South | Central |
|---|---|---|---|
| 24161 | 29861 | 13238 | 38262 |
| ©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |