
To let the developer system access the
Rational® Common Reporting data warehouse for running the reports, catalog the data
warehouse and run the reports.
About this task
To configure the
Rational Common Reporting database catalog and the
Rational Common Reporting models:
- Catalog the data warehouse.
- If the database is installed locally, create a database.
- Run the following command under the [rational_insight_installation_directory]/cognos/bin directory:
#./catmanage DB2 "DSN=RICTG;UID=USERNAME;PWD=PASSWORD" -c
where USERNAME and PASSWORD are the user name and password of a valid DB2® user account.
- Restore the catalog by running the following command
under the [rational_insight_installation_directory]/cognos/bin directory:
#./catrestore DB2 "DSN=RICTG;UID=USERNAME;PWD=PASSWORD" [INSTALLDIR]/datamgr/insight_catalog/OOTBDMCatalog.ctg
where USERNAME and PASSWORD are the user name
and password of a valid DB2 user
account.
- Run the ETL jobs.
- To list all fact jobs in catalog, run the following
command under the [rational_insight_installation_directory]/cognos/bin directory:
#./catlist DB2 "DSN=RICTG;UID=USERNAME;PWD=PASSWORD" J
where USERNAME and PASSWORD are the user name and password of a valid DB2 user account.
- To run the fact job, run the following command under
the [rational_insight_installation_directory]/cognos/bin directory:
#./rundsjob DB2 "DSN=RICTG;UID=USERNAME;PWD=PASSWORD" OOTBE2E
where USERNAME and PASSWORD are the user name and password of a valid DB2 user account.