How to fix the cross-object Performance by Cell reports
Use this procedure to fix the old versions of the following cross-object reports so they function with the new data model.
*
Campaign Performance Summary by Cell
*
Campaign Performance Summary by Cell (with Revenue)
*
Campaign Performance Summary by Cell by Initiative
Complete the following steps.
1.
Open the report in IBM® Cognos® Report Studio.
2.
Click the lock icon on the toolbar to unlock the report.
3.
Browse to the Query Explorer and open the Report Query for a list of all the query items in the report.
4.
For all three reports, remap the following query items as follows:
Query item
Mapping
Number of Offers Given
[Campaign Performance Summary].[Campaign Cell CH with Controls Summary].[Number of Offers Given]
Response Transactions
[Campaign Performance Summary].[Campaign Cell RH with Controls Summary].[Response Transactions]
Unique Recipients
[Campaign Performance Summary].[Campaign Cell CH with Controls Summary].[Unique Recipients]
Unique Responders
[Campaign Performance Summary].[Campaign Cell RH with Controls Summary].[Unique Responders]
Unique Recipients Control Group
[Campaign Performance Summary].[Campaign Cell CH with Controls Summary].[Unique Recipients Control Group]
Unique Responders Control Group
[Campaign Performance Summary].[Campaign Cell RH with Controls Summary].[Unique Responders Control Group]
5.
For the report with revenue, remap for the Gross Revenue item as follows:
[Campaign Performance Summary].[Campaign Cell RH with Controls Summary].[Gross Revenue]
6.
Update the formula for the Responder Rate Control Group to be the following:
IF(([Unique Responders Control Group]/([Unique Recipients Control Group]
* 1.00)) is missing)
THEN (0)
ELSE(([Unique Responders Control Group]/([Unique Recipients Control Group]
* 1.00)))
7.
From the Detail Filter list, select the first detail filter and edit it so it looks like this:
[Campaign Performance Summary] . [Campaign] . [Campaign ID] in (?CampaignIds?)
8.
From the Detail Filter list, delete the second detail filter – the one that looks like this:
[Campaign Performance Summary].[Responder Rate Control Group at Cell Level].[Campaign ID] in (?CampaignIds?)
9.
Lock the report.
10.
Do the following in Report Studio for each report.
a.
Go to File > Report Package.
b.
Select Unica Campaign Package and click OK.
c.
Fill in prompts on the report as necessary.
d.
After the report is validated, click Close in the Validation Response window.
11.
Save and run the report.
Copyright IBM Corporation 2012. All Rights Reserved.