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
In the following report script, the <ACCON command includes all members in the report script, 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 See Also