In this lesson you will learn how to update the Framework
Manager model to deploy the changes that you made to the default ETL
project (Lesson 2.2) after you customized the default schema of the
data warehouse (Lesson 2.1).
In lesson 2.1, you added a new fact table named F_DEFECT_METRICS
to the default schema, and related this fact table to a dimension
table named D_COMPONENT_LABEX. In lesson 2.2, you added the fact table
and its related dimension table to the Data Manager build. In this
lesson, you will learn how to change the Framework Manager model to
incorporate changes made to the data warehouse schema and to expose
the changes to report designer.
In this lesson, you will:
- Import the Data Manager fact table and dimension table into Framework
Manager
- Create query subjects from the imported tables
- Build a relationship between the two new query subjects
- Define a namespace for the related query subjects
- Deploy the new namespace for publication
Prepare the Framework Manager project- Start Framework Manager.
- From the File menu, click .
- In the From box, click Browse to
go to the default installation directory (C:/Program Files/IBM/Rational
Insight/framemgr/Rational Insight Reporting Data Model (DW)),
and select the Rational Insight Reporting Data Model (DW).cpf file.
- In the To field, type the project name.
By default, the project name and the directory where the project is
saved are the same.
- In the Location field, type the new location
or click Browse and select the new project
location and click OK. When you save the project
make sure that you save the project in a different folder.
- Click Finish. Save the project file (.cpf)
and all related files in one folder.
Import the metadata of new tables to the physical metadata
layer- In the Project Viewer panel, expand the Rational
Insight Reporting Data Model (DW) node, select the Physical
Metadata namespace, right-click, and click Run
Metadata Wizard.
You are now ready to use the wizard
pages to import the Data manager metadata into the Framework manager
build. You will do so by importing the fact table named F_DEFECT_METRICS
and dimension table named D_COMPONENT_LABEX from Data Manager into
Framework Manager.
- Select Data Sources, and click Next.
- Select the RIDW datasource, and click Next.
- Expand the RIDW node to list the tables
under Tables, and select the dimension table D_COMPONENT_LABEX and
the fact table F_DEFECT_METRICS. Click Next.
- On the Generate Relationship page, accept
the defaults, and click Next. Click Finish.
- Expand the new F_DEFECT_METRICS table and
look at the Properties view to make sure that
the columns have the correct properties:
- DEFECT_METRICS_ID is an Identifier
- TOTAL_DEFECTS is a Fact
- COMPONENT_ID is an Identifier
- REC_DATETIME is an Attribute
- DATE_ID is an Identifier
Create query subjects- In the Project Viewer panel, expand the node, select Fact,
right-click, and click .
- Specify the name of the query subject to be Defect
Metrics, and click OK.
- In the Query Subject Definition tab, expand
the Physical Metadata node, select the F_DEFECT_METRICS table,
drag the table and drop it in the Query Items and Calculations section.
Click OK.
You have now created a new query
named Defect Metrics, which is linked to the
F_DEFECT_METRICS fact table. Next, you will create another query,
this time for the D_COMPONENT_LABEX dimension table.
- In the Project Viewer panel, expand the node, select Dimensions,
right-click, and click .
- Specify the name of the query subject to be Component
LabEx, and click OK.
- In the Query Subject Definition tab, expand
the Physical Metadata node, select the D_COMPONENT_LABEX table,
drag the table and drop it in the Query Items and Calculations section.
Click OK.
You have now created two query subjects: one from a fact
table and the other from a dimension table. Next, you will create
a relationship between these two query subjects.
Build relationships- In the Project Viewer panel, expand the node, expand the Fact folder,
locate the Defect Metrics query subject, select
it, right-click, and click .
- In the Relationship Expression tab, click
next to the Query subject field at
the right of the panel, expand the Rational Insight Reporting
Data Model (DW) node, locate and select the Component
LabEx query subject, and click OK.
- Select COMPONENT_ID in both the boxes,
and click OK.
You have now linked the two query subjects through the common
attribute
COMPONENT_ID.
Convert to
star schema- In the Project Viewer panel, expand the node, expand the Fact folder,
locate the Defect Metrics query subject, select
it, right-click, and click .
- In the Project Viewer panel, expand the node, expand the Dimension folder,
locate the Component LabEx query subject, select
it, right-click, and click .
- Expand the Fact folder to locate the Defect
Metrics measure, select it, right-click, and click Create
Star Schema Grouping.
- Make sure that both the Available objects are
selected, and click OK.
You have now created a namespace
named Defect Metrics for the linked query subjects. Next, you need
to add this namespace to the publish cycle.
Expose the metrics
in the business view- In the Project Viewer panel, expand the Rational
Insight Reporting Data Model (DW) node, locate the Defect
Metrics namespace, select it, drag it, and drop it into
the namespace.
- In the Project Viewer panel, expand the Rational
Insight Reporting Data Model (DW) node, expand the Packages namespace,
right-click Reporting Data Model (DW), and
click .
- Ensure that the Defect Metrics namespace
is selected in the node. Click OK.
- Right-click Reporting Data Model (DW) and
click Publish Definition.
Remember: You
are republishing the entire package; the process might take several
minutes.
You have used an existing publishing package named Reporting
Data Model (DW) and updated the package to include the Defect Metrics
namespace. You will now be able to access the F_DEFECT_METRICS fact
table and the D_COMPONENT_LABEX dimension table in Report Designer,
and create reports from the attributes of these tables.