Adding views to the HCL Cognos data model
You can add views or tables to the HCL® Cognos® data model. Use HCL 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 Campaign database to create the additional reporting views.
About this task
The following example task shows how to add views or tables to the HCL 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 Campaign data model, complete the following steps.