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.ISGENERATIONDEMO AS
IsGeneration([Date].[Fiscal].CURRENTMEMBER, 2)
SELECT {MEASURES.ISGENERATIONDEMO} ON 0,
[Date].[Fiscal].MEMBERS ON 1
FROM [AdventureWorksMF]