IsGeneration

Returns TRUE if the member is in a specified generation.

Syntax

IsGeneration ( member, index )

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

returns

East West South Central
24161 29861 13238 38262

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com