Adding new views to IBM Cognos data model

You can add new views or tables to the IBM® Cognos® data model. Use IBM Cognos Framework Manager features to query the views or tables and then import the additional items in the data model.

About this task

The following example procedure shows how to add new views or tables to the IBM Cognos data model. For this example, assume that you changed the Over Time Variations for the Campaign Peformance reporting schema and now need to import the change in the Cognos model. You have already completed the following tasks:

  • Modified the Campaign Performance schema by adding Quarterly to the Over Time Variations options.
  • Used the Reporting SQL Generator to generate the view creation script. This script now contains instructions to create the following additional reporting views: UARC_CCCH_QU, UARC_CCH_QU, UARC_CCRH_QU, UARC_COCH_QU, UARC_CORH_QU, and UARC_CRH_QU
  • Ran the generated script in the Campaign database to create the additional reporting views.

Now, to add the new reporting views to the Cognos Campaign data model, you would complete the following steps.

Procedure

  1. Make a backup of the Campaign model.

    That is, browse to the Cognos/models directory and copy the CampaignModel subdirectory. In a distributed Cognos environment, the models directory is in a location on the system running the Content Manager.

  2. In Framework Manager, open the Campaign project and expand the Import View node
  3. Select the Campaign Performance folder and run the Metadata Wizard (accessed through the right-mouse menu).
  4. Use the Metadata Wizard to import the new views.
  5. Expand the Model View > Campaign Performance node and model a new entry named Campaign Performance by Quarter.

    For help with this step, examine the other entries for reference. Be sure to maintain the same structure and relationships that are included in the other over time variation nodes. Additionally, consult the Cognos BI Framework Manager User Guide for the following information:

    • Creating a namespace.
    • Creating star schema groupings.
    • Adding joins.
  6. Expand the Business View and create a shortcut to the Campaign Performance by Quarter node in the Model View .
  7. Save the model.
  8. Publish the package to the Cognos content store.
  9. Open Report Studio and create a new report with the objects from the Campaign Performance by Quarter schema that you created.