Configuring and publishing the data model

When you set up the IBM® EMM system tables as a Cognos® data source, you might have logged in as a user who is not the owner of the IBM® EMM application system tables. In this situation, you must configure and publish the data model.

You do not need to configure and publish the data model of the data source login that you used is the owner of the IBM® EMM application system tables.

This step is optional for eMessage reports.

1.	Complete the following tasks to configure and publish the data model:

2.	Locate the Model directory under the reports package installation, and copy all the files in the Model directory to anywhere under your Cognos® Framework Manager installation directory. The files constitute the application-specific data model.

3.	In Framework Manager, open the project file. The project file has a .cpf extension, and the file name includes the IBM® EMM application name, for example ProductNameModel.cpf.

4.	Open the data model for the application and complete the following steps:

a.	In the Project Viewer, expand Data Sources.

b.	Click the data source for the application.

c.	Update the data source as described in the following table:

Catalog: Enter the name of the IBM® EMM application database.

Schema: Enter the name of the IBM® EMM application database schema. For example, dbo

Oracle

Schema: Enter the name of the IBM® EMM application database schema.

DB2®

Schema: Enter the name of the IBM® EMM application database schema.

5.	Save and republish the package.

For more information on publishing a package in IBM® Cognos®, see Cognos® Framework Manager User Guide.