Preparing the data warehouse

The data warehouse holds the configuration information of the product data sources. It also holds the normalized operational data store, and the transformed fact and dimension tables, all of which are loaded through the ETL process. If you chose the automatic installation option while installing the Rational® Common Reporting data warehouse, the data warehouse for the ETL process is already prepared and no further action is required.

Before you begin

Procedure

  1. If you chose the manual installation option while installing the Rational Common Reporting data warehouse, create a database by running the script that is placed by the installer on the computer when installation program for Rational Common Reporting is run. The instructions for locating the script and the steps for running the script are explained in the Configuring the data warehouse section of the Installing and Upgrading topics (related links at the bottom of this page).
  2. For database users having access to the data warehouse, grant the following access privileges: select, insert, update, delete, analyze table, compute, stored procedure execution, and stored function execution. For information about granting privileges to users, see the database product documentation.

Feedback