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.

About this task

Note: 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.

Procedure

Complete the following tasks to configure and publish the data model:
  1. 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.
  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 complete the following steps:
    1. In the Project Viewer, expand Data Sources.
    2. Click the data source for the application.
    3. Update the data source as described in the following table:
    Table 1. Data source

    This two-columned table provides the name of the database in one column, and the fields in the second column.
    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.

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