IsGeneration

Returns TRUE if the member is in a specified generation.

Syntax

IsGeneration ( member, index )

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

See Also

• Generation
• IsLevel