Defining an in-database aggregate automatically

You can automatically define an in-database aggregate when primary keys in the aggregate table match the level keys in dimensions of a dynamic cube. This allows you to create relationships between the dimensions and the aggregate table.

IBM® Cognos® Cube Designer can create these relationships automatically if the aggregate table contains the following:

  • Measures that match the measures in the in-database aggregate.
  • Dimensions that match the dimensions in the in-database aggregate.
  • Data at the highest level of aggregation that is required by the in-database aggregate.

Procedure

  1. Open the Cube editor for the dynamic cube in which you want to define an in-database aggregate.
  2. Click the Aggregates tab.
  3. Drag the required aggregate table from the Data Source Explorer to the Aggregates tab.

    An in-database aggregation is created in the Aggregates tab. The cube also appears under the In-Database Aggregates folder in the Project Explorer tree. Where matching measures and dimensions are found in the in-database aggregate, Cognos Cube Designer maps each of these items to the aggregate table. Where possible, it also attempts to identify the highest level of aggregation that is required and roll up dimensions.

    The ability to automatically map is dependent on how the aggregate tables are set up.

Results

The in-database aggregate is now complete. You can fine-tune the mapping by following step 4 onwards in the topic Defining an in-database aggregate manually. When you finish, you can test the validity of the in-database aggregate. For more information, see Validate a project and individual objects.