This section describes the metadata model for IBM® Rational® Insight
data warehouse (RIDW).
It provides a business view of the information in the source data
to simplify building reports, analyses, and queries.
The business view:
- Organizes items in folders that represent business areas for reporting
- Formats items using numeric, currency, date, time, and other formats
- Presents multilingual folder and item names, descriptions, tips,
and data so that users can operate in their language of choice
- Automates the generation of SQL queries sent to the relational
data source
- Specifies default prompting
The RIDW model contains the following entities.
Physical metadata
This layer contains query subjects representing the imported tables
and relationships between them. The relationships are inferred from
the relationships defined in the imported file. It includes fact tables,
dimension tables, and view tables to enable drilling down to details.
Dimensions
This layer contains regular dimensions, measure dimensions, and
scope relationships. The regular dimension objects are based on query
subjects representing dimension tables. They may be either conformed
or non-conformed. The measure dimension objects are based on query
subjects representing fact tables. The scope relationships are inferred
from the relationships defined in the imported file.
Consolidate view
This layer contains query subjects that represent data in terms
of business needs and report requirements. Filters, calculations,
and parameter maps are defined in this view. Rational Insight uses the following settings
in this layer:
- Add filters in every query subject to not show records whose ID
equals -1.
- Change the property Is Hidden to True in some query items. As
query items representing IDs are not used in reports, they are set
to be hidden from report authors.
- Add metrics in query subjects to contain calculated values, such
as percentages, maximum values, minimum values, and averages based
on underlying facts to simplify report authoring.
- Change query items in query subjects representing normalized relational
tables.
Business View
This layer contains shortcuts to the query subjects in the Operational
data view. The shortcuts are grouped in star schema in namespaces
that are further grouped into business domains.
When you use the
Rational Insight sample metadata
model, the following business domains are available:
- Change management, which contains metrics about requests and tasks
- Configuration management, which contains metrics about activities,
builds, and file versions
- Project management, which tracks metrics about project performance
- Quality management, which tracks metrics about test information,
execution results, test cases, test suites, and builds
- Requirement management, which tracks metrics about requirements