Selecting Multiple Members
You can select members dynamically based on criteria that you specify.
You define criteria by creating expressions of members, boolean operations, and commands.
Boolean operators enable you to specify precise member combinations for the report, which is useful for dealing with large volumes of data. Use the AND
, OR
, UNION
, and NOT
boolean operators, combined with expression commands, to refine your member selections.
To select multiple members based on criteria:
Tip:
If you are using three members, use two pairs of parentheses. For example, if you select descendants of Market and you want to exclude East, West, and South, your advanced member selection query should be as follows:
Descendants of Market AND NOT (East AND NOT (West AND NOT SOUTH))