When you set up the HCL®
EMM system
tables as a Cognos® data source,
you might have logged in as a user who is not the owner of the HCL
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 HCL
EMM application
system tables.
This step is optional for eMessage reports.
Procedure
Complete the following tasks to configure and publish
the data model:
- 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.
- In Framework Manager, open the project file. The project
file has a .cpf extension, and the file name
includes the HCL
EMM 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 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 HCL
EMM application
database.
- Schema: Enter the name of the HCL
EMM application
database schema. For example, dbo
|
Oracle |
- Schema: Enter the name of the HCL
EMM application
database schema.
|
DB2® |
- Schema: Enter the name of the HCL
EMM application
database schema.
|
- Save and republish the package.
For more information
about publishing a package in IBM Cognos, see Cognos Framework Manager User Guide.