ISGENERATION
Description:
This function is used to return whether a specified member is in a specified generation.
Syntax:
IsGeneration(Member_Expression, Generation_Number)
Return Type:
LOGICAL
Parameters:
Parameter | Description |
|---|---|
Member_Expression1 | It is a valid MDX expression that returns a member. |
Generation_Number | It is a valid numeric expression that specifies the generation against which the specified member is evaluated. |
Example:
WITH MEMBER [Measures].[Is Gen 2] AS
IsGeneration([Product].[Product Categories].CurrentMember, 2)
SELECT
[Measures].[Is Gen 2] ON COLUMNS,
[Product].[Product Categories].[Sub Category].Members ON ROWS
FROM [AdventureWorksMF_ValueBased]