Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All


SQL Server 2000


Returns TRUE if a specified member is in a specified generation, FALSE otherwise.


IsGeneration(«Member»,«Numeric Expression»)


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.


The following example returns TRUE if [Time].CurrentMember is part of the second generation:

IsGeneration([Time].CurrentMember, 2)
© 2015 Microsoft