
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 ORACLE "USERNAME/PASSWORD@RICTG" -c
where USERNAME and PASSWORD are the user name
and password of a valid Oracle user account.
- Restore the catalog by running the following command
under the [rational_insight_installation_directory]/cognos/bin directory:
#./catrestore ORACLE "USERNAME/PASSWORD@RICTG" [INSTALLDIR]/datamgr/insight_catalog/OOTBDMCatalog.ctg
where USERNAME and PASSWORD are the user name
and password of a valid Oracle 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 ORACLE "USERNAME/PASSWORD@RICTG" J
where USERNAME and PASSWORD are the user name and password of a valid Oracle user account.
- To run the fact jobs, run the following command under
the [rational_insight_installation_directory]/cognos/bin directory:
#./rundsjob ORACLE "USERNAME/PASSWORD@RICTG" OOTBE2E
where USERNAME and PASSWORD are the user name and password of a valid Oracle user account.