Turns off member accumulation.
Note: | By default, the report script uses <ACCOFF. |
Syntax
<ACCOFF
Notes
<ACCOFF selects members of the same dimension only if the select commands of the dimension follow one another in the report script. If a select command containing another dimension interrupts, the report script ignores the previous select commands. <ACCOFF can be used in multiple report scripts where the script redefines only a few select statements from the previous script.
Example
In the following report script, <ACCOFF excludes the two members that precede East (100-10 and 200-10), because East is from a different dimension. The report script includes 300-10 and 400-10, which follow East.
<PAGE (Measures) Sales <ASYM <COLUMN (Scenario, Year) Actual Budget Jan Feb <ROW (Product, Market) <ACCOFF "100-10" "200-10" "East" "300-10" "400-10" !
This example produces the following report:
Sales Actual Budget Jan Feb ======= ======= 300-10 East 999 770 400-10 East 562 580
See Also