Turns off member accumulation.
<ACCOFF
By default, the report script uses <ACCOFF.
<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 succession of the select commands, the report script ignores the previous select commands encountered before the select command of the new dimension. <ACCOFF can be used in multiple report scripts where the script redefines only a few select statements from the previous script.
In the following report script, the <ACCOFF command excludes the previous two members, 100-10 and 200-10, that precede East, because East is a member from a different dimension. The report script proceeds to include 300-10 and 400-10, which follow East in the script.
<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 |
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |