ACCON
The Essbase Report Writer ACCON command 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
Related Topics