Logical Functions: IsGeneration(): Conditional Logic within Filter Expressions
In Logical Functions: IsGeneration(): Conditional Logic within Calculations, another article within my MDX Essentials series, we introduced the IsGeneration() function from the perspective of its use within a calculation. We discussed the straightforward purpose of this logical function: IsGeneration() provides us a means of testing whether or not a specified member exists within a specified generation. As a part of introducing the function, we noted that the effective use of IsGeneration() as a testing mechanism is dependent upon a good understanding of the manner with which generation numbers are assigned within Analysis Services. For this reason, we overviewed the generation concepts, within our preliminary commentary surrounding the function, in Logical Functions: IsGeneration(): Conditional Logic within Calculations.
In this article, we will examine IsGeneration(), once again as a conditional logic modifier, but within the context of a filter. Combining IsGeneration() with the MDX Filter() function is another way we commonly see it in action in the business environment, and our exposure to the practical aspects of its employment in this way will serve to enhance our overall awareness of the potential of IsGeneration(). From the perspective of the use of the IsGeneration() function in combination with Filter(), this article will include:
- A review of the general syntax surrounding the function;
- Illustrative examples of uses of the function in practice exercises;
- A brief discussion of the MDX results obtained within each of the practice examples.
Tags: mdx