In response to retrieval requests, values loaded to level 0 cells are aggregated and formulas of accounts members are calculated.
To improve retrieval performance, Essbase can materialize and store aggregate views. The stored results are called aggregations. For databases for which you have Calculation permissions, you can use the Aggregation Design Wizard to design aggregations.
For complete information about calculating aggregate storage databases, see the Oracle Essbase Database Administrator's Guide.
To design aggregations:
From Enterprise View or a custom view, select an aggregate storage database.
Right-click, and select Design aggregation.
In the Aggregation Design Wizard, select a task, and follow the instructions.
If you need assistance, click Help.
“Calculating Aggregate Storage Databases” in the Oracle Essbase Database Administrator's Guide
execute aggregate process (MaxL) in the Oracle Essbase Technical Reference
query database (MaxL) in the Oracle Essbase Technical Reference