Configuring and publishing the data model

You must configure and publish the data model only if, when you set up the data source, you were logged in as a user who is not the owner of the application system tables.

About this task

Note: You do not need to configure and publish the data model if the data source login that you used is the owner of the HCL® Marketing Software application system tables.
Note: This task is optional for eMessage reports.

To configure and publish the data model, complete the following steps.

Procedure

  1. In the Model directory under the reports package installation, copy all files in the Model directory to 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 HCL Marketing Software 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, depending on your database type:
    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 HCL Marketing Software application database.
    • Schema: Enter the name of the HCL Marketing Software application database schema. For example, dbo.
    Oracle
    • Schema: Enter the name of the HCL Marketing Software application database schema.
    DB2®
    • Schema: Enter the name of the HCL Marketing Software application database schema.
  4. Save and republish the package.

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