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
-
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.
-
In Framework Manager, open the Campaign project and expand the Import
View node.
-
Right-click the Campaign Performance folder and select
Metadata Wizard.
-
Step through the Metadata Wizard to import the new views.
-
Expand the 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
-
Expand the Business View and create a shortcut to the
Campaign Performance by Quarter node in the Model
View.
- Save the model.
- Publish the package to the Cognos content
store.
-
Open Report Studio and create a report with the objects from the Campaign
Performance by Quarter schema that you created.