ACCON

Turns on member accumulation.

Note:

By default, member accumulation is off.

Syntax

<ACCON

Notes

This command selects all members, regardless of the order of the select statements. Use this command to mix members from different dimensions in select statements.

Example

The following report script is designed for the Sample Basic cube, available in the gallery. The <ACCON command causes inclusion of all members, regardless of dimensionality.

<PAGE (Measures)
Sales
<ASYM
<COLUMN (Scenario, Year)
Actual Budget
Jan Feb
<ROW (Product, Market)
<ACCON
"100-10"
"200-10"
"East"
"300-10"
"400-10"
!

This example produces the following report:

                    Sales
                Actual   Budget
                   Jan      Feb 
                =======  =======
100-10  East     1,812    1,640
200-10  East       647      630
300-10  East       999      770 
400-10  East       562      580