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 Unica application system
tables.
Note: This task is optional for Unica Deliver
reports.
To configure and publish the data model, complete the following steps.
Procedure
- 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.
- In Framework Manager, open the project file. The project file has a .cpf extension, and the file name includes the Unica application name, for example ProductNameModel.cpf.
- Open the data model for the application and complete the
following steps:
- In the Project Viewer, expand Data Sources.
- Click the data source for the application.
- 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 Unica application database.
- Schema: Enter the name of the Unica application database schema. For example, dbo.
Oracle - Schema: Enter the name of the Unica application database schema.
DB2® - Schema: Enter the name of the Unica application database schema.
- Save and republish the package.
For more information about publishing a package in IBM® Cognos®, see the Cognos® Framework Manager User Guide.