Reusing operational metadata models

IBM® Rational® Insight implements support for using the same metadata model for multiple data sources. To use an existing metadata model, you must add the data source and then select it when creating or modifying a report.
About this task
It is common to have multiple data sources sharing the same data structure. For instance, you might have multiple Rational ClearQuest® user databases created with the same Rational ClearQuest schema and multiple Rational RequisitePro® projects created with same templates. In these cases, you can use the same metadata model to describe the data structures and the same report designs to visualize the data.

To add a data source and to select that source for your report:

Adding a data source

Before you begin
You need to know the URL of the data source that you are adding.
  1. Start XML Data Configuration.
  2. Open the XML data configuration file used by the operational metadata model. By default, all XML data configuration files used by the operational metadata models are located in the rational_insight_installation_directory\Rational Insight\dataconfig\configs\live data config\ directory.
  3. Expand the tree in XML Data Explorer view and identify the resource group category and the default resource group used in the metadata model.
  4. Drag the resource group and drop it under the same resource group category.
  5. To create a new copy of the resource group, select Copy in the context menu.
  6. Double click the new resource group to open it.
  7. Modify the name and URL to point to the new data source.
  8. Save the changes and close the XML data configuration file.
Results
The new data source becomes available in the reports. If the cache is activated in the reporting server, wait until the cache times out. By default, the cache is activated and the timeout is 15 minutes.

Selecting a data source in a report

About this task
Each operational metadata model contains a parameter that you can use for specifying the name of the data source (corresponding to the name of the resource group defined in the XML data configuration file). This parameter is available to reports using the metadata model. Each operational metadata model also defines a query object that provides a list of available data sources. As a report author, you can define a list prompt to list the names of available data sources, and the selected value will be used as input for the data source name parameter. For more information on each operational metadata model and on parameters and the query objects, see the operational metadata topics for the products.

Feedback