Updating the metadata for the data warehouse

After you upgrade to Rational® Insight 1.0 Fix Pack 1, you must update the metadata for the data warehouse by importing the new data models into the IBM® Cognos® Framework Manager projects and correcting the duplicate references.
Before you begin
Before you update your data warehouse, make sure that you have backed up the data warehouse. See the related links at the bottom of this page.
About this task
To update the metadata for the data warehouse, you must rename the data sources, import the objects into IBM Cognos Framework Manager projects, reorder the elements in the Business View folder, rename and remove duplicate data sources, remove a dimension filter, correct the shortcuts, remove duplicate relationships, and add columns to objects.

To upgrade the metadata for the data warehouse:

  1. Rename the data sources.
    1. Start Cognos Framework Manager and open your Rational Insight Data Warehouse project.
    2. Expand Rational Insight Reporting Data Model (RIDW) > Data Sources, and click Rational Data Warehouse.
    3. On the Properties page, change Rational Insight Data Warehouse to Rational Insight Data Warehouse1.
    4. If you get a warning message, click OK.
    5. Save the changes.
  2. Import the latest models into IBM Cognos Framework Manager projects.
    1. Right-click the Rational Insight Reporting Data Model name space and click Run Metadata Wizard.
    2. Click IBM Cognos 8 Model and click Next.
    3. Browse and select the Rational Insight Reporting Data Model (RIDW).cpf file of the latest Rational Insight data warehouse project and click Next.
    4. Select Rational Insight Data Warehouse and, for duplicate elements, select Do not import this object. Click Next twice.
    5. When the import process is complete, click Finish.
      Note: Relationships with existing items are not imported, so you must rebuild them. Existing items are not overwritten, and you must redo any changes.
  3. Reorder the elements in the Business View folder.
    1. Expand the Rational Insight Reporting Data Model name space and click Business View.
    2. Right-click a folder and click Reorder. Repeat for all folders in the Business View folder.
    3. Close Cognos Framework Manager.
  4. Rename the data sources back to their previous names.
    1. In a text editor, open the model.xml file of the project. The default location of the file is rational_insight_instllation_directory\framemgr\Rational Insight Reporting Data Model (RIDW).
    2. Find the XML element <dataSources>. Copy the text between the opening and closing tags of the XML element and paste to a temporary text file.
    3. In the model.xml file, find all occurrences of Rational Insight Data Warehouse1 and replace with Rational Insight Data Warehouse.
    4. Copy the text from the temporary file in step b and paste it within the <dataSources> tags of the model.xml file.
    5. Save the model.xml file and close it.
  5. Remove the duplicate data sources.
    1. Start Cognos Framework Manager and open your Rational Insight Data Warehouse project.
    2. Expand Rational Insight Reporting Data Model > Data Sources.
    3. Delete Rational Insight Data Warehouse1.
  6. Remove the filter of the iteration dimension.
    1. Expand the Rational Insight Reporting Data Model > Rational Insight Reporting Data Model > Dimensions.
    2. Double-click the Iteration dimension, and click Filters, and click on the filter listed in Filters.
    3. Click Delete.
    4. Save the changes.
  7. Correct the errors in shortcuts to queries.
    1. Expand the Rational Insight Reporting Data Model > Rational Insight Reporting Data Model > Consolidate View > consolidated tables contributing to facts.
    2. Right-click Requests Contributing to Request Resolution Metrics with Test Plan, and click Create > Shortcut.
    3. Drag the shortcut and drop it in the Business View > Change Management > Request Resolution Metrics with Test Plan name space.
    4. In the folder, delete the existing Requests Detail shortcut and rename the shortcut you copied in step c to Request Detail.
  8. Remove the duplicate relationships.
    1. In the Search box, type Request <--> Request Metrics (Current Snapshot) and click Search.
    2. Delete the relationship that is found and listed.
    3. Save the changes.
  9. Add a summary column to the VW_REQUEST object.
    1. Expand the Rational Insight Reporting Data Model (DW) > Physical Metadata.
    2. Double-click VW_REQUEST and click OK to close the Query Definition page. The query subject is updated and a column named SUMMARY is added to the VW_REQUEST query.
    3. Expand the VW_REQUEST query, right-click Name and click and click Show Object Dependencies. All calculation definitions that are defined as [Physical Metadata].[VW_REQUEST].[Name] are listed in the Dependenent Objects view. To see a query item in Project Viewer, click on a result in the Dependenent Objects. The query subject to which the query item belongs is the dependent object of VW_REQUEST.
    4. For each of the dependent query subjects that are found in step c, double-click to open the Query Subject Definition page and drag all the undefined columns of Physical Metadata > VW_REQUEST in the Available Model Objects box to the Query Items and Calculations box. Specify the column name to be Summary.
    5. Save the changes.
    6. Select all the attributes of the query subject, right-click, and select Reorder.
    7. Save the changes.
  10. Add a PREV_Summary column to the VW_REQUEST_CHANGE_HISTORY object.
    1. Expand the Rational Insight Reporting Data Model (DW) > Physical Metadata.
    2. Double-click VW_REQUEST_CHANGE_HISTORY and click OK to close the Query Definition page. The query subject is updated and a column named PREV_Summary is added to the VW_REQUEST_CHANGE_HISTORY query.
    3. Expand the VW_REQUEST_CHANGE_HISTORY query, right-click Name and click and click Show Object Dependencies. All calculation definitions that are defined as [Physical Metadata].[VW_REQUEST_CHANGE_HISTORY].[Description] are listed in the Dependenent Objects view. To see a query item in Project Viewer, click on a result in the Dependenent Objects. The query subject to which the query item belongs is the dependent object of VW_REQUEST_CHANGE_HISTORY.
    4. For each of the dependencies that are displayed in step c, double-click to open the Query Subject Definition page and drag all the undefined columns of Physical Metadata > VW_REQUEST_CHANGE_HISTORY in the Available Model Objects box to the Query Items and Calculations box. Specify the column name to be PREV_Summary.
    5. Save the changes.
    6. Select all the attributes of the object, right-click, and select Reorder.
    7. Save the changes.
    8. Close Cognos Framework Manager.

Feedback