Rational ProjectConsole Designer Help
The Rational ProjectConsole warehouse is based on a data warehousing star schema table design, which is an excellent means of optimizing data reporting. (For details on star schemas, see the many existing resources available on data warehouse concepts and optimization.)
The Rational ProjectConsole Dashboard warehouse stores data extracted from your sources in target tables. The target tables, which are designed based on a star schema, represent data using two types of tables: a measure (or fact) table and dimension tables.
A star schema consists of a single measure table and a number of dimension tables. Dimension tables contain the attributes that describe the records in the measure table. The measure table consists of measures and references to dimension tables. The references to the dimensions indicate the attributes of a measure. When constructing star schemas you must create the dimension tables first so that their fields exist prior to creating the measure tables that reference them.
For more information about dimension and measure tables, see Working with target tables.
For more information about using star schema designs, see Rational ProjectConsole repository: Design and components.