You use the Aggregation Design wizard to precalculate and store aggregations for aggregate storage databases that contain data and to which you are granted Calculation permission.
The aggregation process includes two phases: view selection and materialization. You can perform the processes separately or simultaneously.
If you select the “Materialize aggregation in the background” option, as the aggregation processes:
You can continue working.
You cannot shut down Essbase Administration Server.
You can check process status in the Background Process Status window.
For detailed information about aggregating aggregate storage databases, see the Oracle Essbase Database Administrator's Guide.
Launching the Aggregation Design Wizard
To launch the Aggregation Design wizard:When you access this page, you may see the following message: “Multiple slices exist in the cube." If you select the accompanying option, “Merge data before proceeding with view selection,” you must exit the wizard and merge data from Enterprise View.
On this page, you select a selection-materialization option:
Use recommended views to materialize aggregation—The selection and materialization processes are combined into one, nonconfigurable operation that is performed by Essbase Server.
Design, materialize, and save aggregation—The selection and materialization processes are separated and, thus, you have more control over the processes.
Use saved aggregation—Materialization is performed through an aggregation script. Thus, you need not select views.
If you select Use recommended views to materialize aggregation, when you click Next, Essbase Server performs the following actions:
If the database contains values from previous aggregations, asks you whether you want to drop the values.
Selects the best set of aggregate views. The selection is based on query time and storage resources. The maximum number of aggregate views that can be selected for one database is 1,023.
Materializes the aggregation and stores the values.
If you select Design, materialize, and save aggregation, when you click Next, the wizard displays, in the following order, the following pages:
If you select the Use saved aggregation option, when you click Next, all aggregation scripts that are saved on the current database are displayed.
In the “Saved aggregations” list, you select a saved aggregation script. Then, you perform one of the following actions:
To materialize the aggregation, select or clear the Replace existing aggregation option, and click Next.
Click Rename, and rename the aggregation.
Click Delete.
Note: | When an aggregation script is executed, the views specified within it are materialized. To save an aggregation as a script, you select the Design, materialize, and save aggregation option (on the first page of the wizard). For information about working with aggregation scripts, see the Oracle Essbase Database Administrator's Guide. |
“Calculating Aggregate Storage Databases” in the Oracle Essbase Database Administrator's Guide.
Performing a Data Load or Dimension Build for Aggregate Storage Databases
execute aggregate process (MaxL) in the Oracle Essbase Technical Reference
execute aggregate selection (MaxL) in the Oracle Essbase Technical Reference
execute aggregate build (MaxL) in the Oracle Essbase Technical Reference
query database (MaxL) in the Oracle Essbase Technical Reference