Defining Aggregations While Building a Cube

The Cube Designer wizard enables you to add aggregations to a cube when the cube is created. You can define aggregations that are built with the cube on the Aggregations page of the Cube Designer wizard. From here you can add and modify aggregations, specify performance options, and choose whether to create the default NWAY aggregation. Selecting the Add button opens the Add Aggregation page of the Cube Designer wizard. It enables you to select from available levels to create an aggregation.

You can also specify stored aggregations for a cube. When you are building a cube in the Cube Designer wizard, you can choose to build from a detail table, a star schema, or a fully summarized table. If you build a cube from a fully summarized table, you can automatically specify aggregations that are stored in aggregation tables. If you are building a cube from a detail table or a star schema, you can also select to include aggregations that are stored in aggregation tables. The General page of the Cube Designer wizard provides the check-box option Cube will use aggregated data from other tables. This option enables you to create your cube using aggregated data from tables other than the detail table or star schema that you selected as the input.

The Aggregation Tables page of the Cube Designer wizard enables you to select aggregation tables for the cube. From these aggregation tables, you can then select stored aggregations to include with the cube. On the Stored Aggregations page of the Cube Designer wizard, you can add and modify a stored aggregation. After you have defined the stored aggregations, you can affix further aggregations that are built with the cube.