Boolean operators enable you to specify precise member combinations within a report—useful when dealing with large outlines. Use the AND, OR, and NOT Boolean operators, combined with extraction commands, to refine member selections within the report script.
To create a Boolean expression using operators, at the point in the script where you want to use linking, enter the format:
<LINK (extractionCommand [operator extractionCommand])
where extractionCommand is the member selection command to retrieve data from, and operator is either the AND or OR operator.
You can use Boolean operators with member selection commands, such as UDA and wildcards. For a list of all valid extraction commands that can be used with the LINK command, see the Oracle Essbase Technical Reference.
The following example selects sweet products from the “100” subtree, plus all products on the same level as “100-10”:
<LINK ((<IDESCENDANTS("100") AND <UDA(Product,Sweet)) OR ONSAMELEVELAS "100"-10")
The following example selects products that are not sweet from the “100” subtree, plus all products on the same level as “100-10”.
<LINK ((<IDESCENDANTS("100") AND NOT <UDA (Product,Sweet)) OR ONSAMELEVELAS "100"-10")
For additional examples of narrowing member selection criteria, see the Oracle Essbase Technical Reference.