Post installation tasks for Rational Common Reporting
After installing Rational® Common Reporting, complete the post installation tasks in this section.
These tasks must be completed in order:
Creating the content store
The content store is a database that Content Manager uses
to store global configuration data, global settings (such as the language
and currency formats shown in the user interface), connections to
data sources, and product-specific content. Design models and log
files are not stored in the content store. You must create the content
store before you can use IBM Cognos 8.
Adding the content store object
Use the IBM Cognos Configuration tool to add the content
store object for the Content Manager item. This allows the Content
Manager to access and store data in the content store that was created
in the previous step.
Importing the product-specific components
Products that integrate with Rational Common Reporting typically provide package specific to the product. These
packages might include items such as reports, data models, ETLs, or
XDC files. Follow the steps in this section to integrate with Rational Common Reporting.
Configuring the XDC file
XML data configuration defines the mapping between the
XML source data and the target relational database tables. These configuration
files specify the location of the XML source (data service server
or any XML document), and how to map the data elements from an XML
source to the relational table structures expected by the Rational Common Reporting report server:
Configuring data warehouse access Rational Common Reporting contains data sources for extracting and storing data
from a defined source during the ETL process. The data warehouse (RIDW)
data source must be configured with the correct connection string.
Also, two data warehouse data sources must be configured with the
credentials that allow the data to be stored.
Running the ETL job
You can extract, transform, and load data with Rational Common Reporting. The extract, transform, and load (ETL) jobs are defined
in the ETL task.
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.