Example: Add new views to IBM® Cognos® data model

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.

1.	Make a backup of the Campaign model.

That is, navigate 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 information about the following:

Creating a new 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 just created.