IsGeneration (MDX)

Checks whether a member is in the specified generation.

Parameters

Name	Type	Cardinality	Default value
member	value-expression	one
	numeric-expression	one

Return

boolean

Description

Returns TRUE if a specified member has specified generation index; FALSE otherwise.

Generation index starts at leaf members with a 0 value. The parent of a leaf has a generation of 1, and so on.

Note that for ragged dimension, intermediate members can have different generations as its children can be at different depths.

Examples

isGeneration(member,0) - leaf member

Returns true for leaf members.

In our example, the leaf of a [City], [Paris] returns true.

Query

WITH
    MEMBER [Measures].[V] AS IsGeneration([Geography].[Paris], 0)
SELECT
    [Measures].[V] ON 0
FROM
    [Sales]

Result

V
true

true

Assertion : MDX Equals

WITH
    MEMBER [Measures].[V] AS isLeaf([Geography].[Paris])
SELECT
    [Measures].[V] ON 0
FROM
    [Sales]

Assertion : MDX Equals

WITH
    MEMBER [Measures].[V] AS true
SELECT
    [Measures].[V] ON 0
FROM
    [Sales]

isGeneration(member,2) - first level member

V
true

isGeneration(NULL,numeric)

V
false

XMLA Properties

Find here the value of the XMLA properties when not specified otherwise.