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
-
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 HCL Marketing
Software 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 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.
|
- Save and republish the package.
For more information about publishing a package in IBM
Cognos, see the Cognos Framework Manager User Guide.