Updating the IBM® Marketing Operations data model

You use Cognos® Framework Manager to update the Marketing Operations data model.

Identify the custom attributes that you want to include in reports and identify the tables (including lookup tables) that are needed for those attributes.

Using Import View in Cognos® Framework Manager, import the metadata for the attributes.

Using Model View in Cognos® Framework Manager, define the appropriate relationship between the custom attributes and objects to which they belong. (For example, relate "Project Custom Attributes" to "Project".) Define appropriate relationships to lookup tables.

Using Business View in Cognos® Framework Manager, define query items and aggregate them into Query Subjects.

Republish the data model.

The Query Subjects for the custom attributes and metrics are now available to report writers.