Step: Configure and publish the data model, if necessary

In Step: Create the IBM Cognos data sources for the IBM EMM application databases, you set up the IBM® EMM system tables as a Cognos® data source. If the data source login you used is not the owner of the IBM® EMM application system tables, perform the step described here. If the data source login you used does own the IBM® EMM application system tables, then you can skip this step.

1.	Locate the Model directory under the reports package installation. Copy all of the files in this Model directory to anywhere under your Cognos® Framework Manager installation directory. These files constitute the application-specific data model.

2.	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).

3.	Open the data model for the application and do the following.

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.

Database

Fields

SQL Server

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.

4.	Save and republish the package.

If you need basic instructions on publishing a package in IBM® Cognos®, see the Cognos® Framework Manager User Guide.