|
Created the offer attribute in the UA_OfferAttribute table.
|
|
Ran the generated script in the Campaign database to update the Offer Custom Attribute reporting view, UARC_OFFEREXTATTR.
|
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.
|
3.
|
Under Import View, select the query object that represents the reporting view for custom offer attributes: Import View > Campaign Custom Attributes > UARC_OFFEREXTATTR.
|
4.
|
Select Tools > Update Object. Cognos® refreshes the columns listed under the node for the view so they reflect all the columns currently present in the UARC_OFFEREXTATTR reporting view in the Campaign database.
|
5.
|
Expand the Model View and select the node that represents custom offer attributes in this view: Model View > Campaign Custom Attributes > Offer Custom Attributes.
|
6.
|
7.
|
Locate the new column and add it to the Model View. Then edit the name of the query item so it can be read easily. For example, the column named LASTRUNDATE in the Import View of the Campaign data model appears as Last Run Date in the Model View.
|
|
Because the Business View contains a shortcut to the Offer Custom Attributes node in the Model View, the new query item now available in the Business View without your having to add it manually.
|
9.
|
Copyright IBM Corporation 2014. All Rights Reserved.
|