< Previous

Lesson 2.3: Customize the default Framework Manager model

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).
Prerequisites:

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
  1. Start Framework Manager.
  2. From the File menu, click Manage Projects > Copy.
  3. 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.
  4. In the To field, type the project name. By default, the project name and the directory where the project is saved are the same.
  5. 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.
  6. 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
  1. 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.

  2. Select Data Sources, and click Next.
  3. Select the RIDW datasource, and click Next.
  4. 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.
  5. On the Generate Relationship page, accept the defaults, and click Next. Click Finish.
  6. 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
  1. In the Project Viewer panel, expand the Rational Insight Reporting Data Model (DW) > Dimensions node, select Fact, right-click, and click Create > Query Subject.
  2. Specify the name of the query subject to be Defect Metrics, and click OK.
  3. 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.

  4. In the Project Viewer panel, expand the Rational Insight Reporting Data Model (DW) > Dimensions node, select Dimensions, right-click, and click Create > Query Subject.
  5. Specify the name of the query subject to be Component LabEx, and click OK.
  6. 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.
    create a query subject

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
  1. In the Project Viewer panel, expand the Rational Insight Reporting Data Model (DW) > Dimensions node, expand the Fact folder, locate the Defect Metrics query subject, select it, right-click, and click Create > Relationship.
  2. In the Relationship Expression tab, click folder icon 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.
  3. Select COMPONENT_ID in both the boxes, and click OK.
    define the relationship
You have now linked the two query subjects through the common attribute COMPONENT_ID.
Convert to star schema
  1. In the Project Viewer panel, expand the Rational Insight Reporting Data Model (DW) > Dimensions node, expand the Fact folder, locate the Defect Metrics query subject, select it, right-click, and click Actions > Convert to Measure Dimension.
    convert to a measure dimension
  2. In the Project Viewer panel, expand the Rational Insight Reporting Data Model (DW) > Dimensions node, expand the Dimension folder, locate the Component LabEx query subject, select it, right-click, and click Actions > Convert to Regular Dimension.
    convert to a regular dim
  3. Expand the Fact folder to locate the Defect Metrics measure, select it, right-click, and click Create Star Schema Grouping.
  4. Make sure that both the Available objects are selected, and click OK.
create a namespace
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
  1. 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 Business View > Change Management namespace.
  2. 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 Edit Definition.
    edit the namespace definition
  3. Ensure that the Defect Metrics namespace is selected in the Business View > Change Management node. Click OK.
  4. 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.

Lesson checkpoint

You imported metadata from the Data Manager, and made the new component visible for publication.
You learned how to:
  • Import fact tables and dimension tables into Framework Manager
  • Create query subjects from tables
  • Build a relationship between two query subjects
  • Define a namespace for query subjects
  • Deploy a namespace for publication
< Previous

Feedback