Analysis Services
IsGeneration
Returns TRUE if a specified member is in a specified generation, FALSE otherwise.
Syntax
IsGeneration(«Member»,«Numeric Expression»)
Remarks
This function returns TRUE if the member indicated in «Member» is in the generation specified in «Numeric Expression». For the purposes of generation indexing, leaf members are generation index 0. All other members are part of the reunion of their children generation + 1. Because of this, a specific member could belong to more than one generation.
Example
The following example returns TRUE if [Time].CurrentMember is part of the second generation:
IsGeneration([Time].CurrentMember, 2)