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
- Open the Cube editor for the dynamic cube in which you
want to define an in-database aggregate.
- Click the Aggregates tab.
- 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.