Applying Multiple Member Filters

When specifying member filters for member selection, you can apply multiple filters simultaneously. You can also specify groupings of filters. Rather than using parentheses to represent filter groupings, Query Designer uses an indentation style.

In general:

These examples show groupings and the results that are produced:

Example 1

Query showing filter on products that are caffeinated and 12-ounce size, then those with intro date later than 06-26-1996.

In this example, Essbase filters members of the Product dimension with the Caffeinated_True and Ounces_12 attributes—that is, all products that are caffeinated and come in 12 ounce sizes. The results of this filter are compared to the next criteria, which are all products having an introduction date later than June 26, 1996. When you preview the results, you get: Cola and Diet Cola.

Example 2

Query showing filter on Market with Large_21000000 attribute or begin with C and UDA of Major Market.

In this example, Essbase filters members of the Market dimension with the Large_21000000 attribute or begin with the letter “C” and with a UDA of Major Market—that is, all Markets with a population of 21,000,000 or beginning with the letter “C,” and is a major market. When you preview the results, you get: New York, California, Texas, Colorado, and Central.

Related Topics

Applying Member Filtering Rules