Adding views to the Cognos® data model

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

Before you begin

Make sure you 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
  • Run the generated script in the Unica Campaign database to create the additional reporting views.

About this task

The following example task shows how to add views to the Cognos® data model. For this example, assume that you changed the Over Time Variations for the Campaign Peformance reporting schema and need to import the change into the Cognos® model.

To add the new reporting views to the Cognos® Unica Campaign data model, complete the following steps.

Procedure

  1. Make a backup of the Unica Campaign model. Browse to the Cognos/models directory and copy the CampaignModel subdirectory.
    In a distributed Cognos® environment, the models directory is on the system running the Content Manager.
  2. In Framework Manager, open the Campaign project and expand the Import View node.
  3. Right-click the Campaign Performance folder and select Metadata Wizard.
  4. Step through 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. Consult the Cognos® BI Framework Manager User Guide for the following tasks:

    • 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 report with the objects from the Campaign Performance by Quarter schema that you created.