Testing the data warehouse data model

Create a report using the data warehouse data model, Reporting Data Model (DW), for testing whether the connection to the data warehouse works.

About this task

Procedure

  1. Open the Cognos Web application at http://server:port/insight.
  2. Open Query Studio by clicking Launch > Query Studio.
  3. 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 Cognos > Public Folders > Reporting Data Models.
  4. 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.
  5. 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.

Feedback