ACCOFF

Turns off member accumulation.

Syntax

<ACCOFF

Default Value

By default, the report script uses <ACCOFF.

Description

<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.

Example

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				

See Also

ACCON

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com