ACCOFF

The Essbase Report Writer ACCOFF command turns off member accumulation (this is the default).

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

The following report script is designed for the Sample Basic cube, available in the gallery. <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

Related Topics

ACCON