Create a report using the data warehouse data model, Reporting Data Model (DW), for testing whether the connection
to the data warehouse works.
Procedure
- Open the Cognos Web application at http://server:port/insight.
- Open Query Studio by clicking .
- Click the Reporting Data Models folder,
and then click the data warehouse model, Reporting Data
Model (DW).
Note: The full path to the Reporting
Data Model (DW) package is .
- To create the report, select the Rational® Quality Manager items from the tree view in the left panel, such as items
from the Test Plan Area, and click Insert.
- In the left panel, run the report by selecting Run Report from the menu, and then select Run with All Data. If prompted for a project name, use
the name that you gave the project area in the data warehouse XDC
file. Assuming that existing data corresponds to the selected artifacts
in Rational Quality Manager, the executed report should return Rational Quality Manager data.
What to do next
After the ETL executes successfully, and both the live and
standard report tests are successful, you can use
Rational Common Reporting.