Export (0) Print
Expand All

IsGeneration

SQL Server 2000

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)
Show:
© 2014 Microsoft