The arguments of the <RESTRICT command let you specify qualifications for selecting rows. Essbase includes only qualified rows in the resulting report output.
<RESTRICT works only on the range of rows that you specify in a row member selection.
Essbase processes the restrictions from left to right, and does not allow grouping with parentheses in the list of arguments.
For example, the following example is not a valid syntax:
RESTRICT (... (@DATACOL(1) > 300 AND @DATACOL(2) < 600)...)
Use only one <RESTRICT per report, as terminated by the ! command. If a report script contains multiple reports, each <RESTRICT overwrites the one in the previous report. For example:
RESTRICT (@DATACOL(1) > @DATACOL(2) AND 800 < @DATACOL(3) OR @DATACOL(4) <> #MISSING)
This <RESTRICT command is equivalent in operation to the following syntax:
RESTRICT (((@DATACOL(1) > @DATACOL(2)) AND (800<@DATACOL(3))) OR (@DATACOL(4) <> #MISSING))