Fixing the cross-object Performance by Cell reports

To manually upgrade your reports version 7.5.1, you must manually upgrade and fix the cross-object Performance by Cell reports, so the reports can function with the new data model.

About this task

You must fix the following reports:
  • Campaign Performance Summary by Cell
  • Campaign Performance Summary by Cell (with Revenue)
  • Campaign Performance Summary by Cell by Initiative

Procedure

Complete the following steps to fix the reports:
  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 query items according to the information in the following table:
    Table 1. Mapping for query items
    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. Complete the following steps in Report Studio for each report:
    1. Go to File > Report Package.
    2. Select Unica Campaign Package and click OK.
    3. Complete prompts on the report as necessary.
    4. After the report is validated, click Close in the Validation Response window.
  11. Save and run the report.