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
- 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.
- In Framework Manager, open the Campaign project and expand
the Import View node
- Select the Campaign Performance folder
and run the Metadata Wizard (accessed through
the right-mouse menu).
- Use the Metadata Wizard to import the new views.
- 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.
- 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 new report with the objects
from the Campaign Performance by Quarter schema
that you created.