Fixing the Offer Performance Summary by Campaign cross-object report

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

Procedure

Complete the following tasks to fix the report:
  1. Open the report in IBM® Cognos® Report Studio.
  2. Browse to the Query Explorer and open the Report Query for a list of all the query items in the report.
  3. Configure the aggregation as follows for the following Campaign Level Counts query items.
    Table 1. Aggregate functions for Campaign Level Counts query items

    This three-columned table provides the query items in one column, the aggregate functions in the second column, and the rollup aggregate functions in the third column.
    Query item Aggregate Function Rollup Aggregate Function
    Number of Offers Given None Automatic
    Response Transactions None Automatic
    Unique Recipients None Automatic
    Unique Responders None Automatic
    Not Contacted Responders None Automatic
    Responses after Expiration None Automatic
    Unique Recipients Control Group None Automatic
    Unique Responders Control Group None Automatic
  4. Configure the aggregation as follows for the following Campaign Level Counts query items.
    Table 2. Aggregate functions for Campaign Level Counts query items

    This three-columned table provides the query items in one column, the aggregate functions in the second column, and the rollup aggregate functions in the third column.
    Query item Aggregate Function Rollup Aggregate Function
    Response Rate Automatic Automatic
    Responder Rate Automatic Automatic
    Responder Rate Control Group Automatic Automatic
    Best Offer Lift Over This Automatic Automatic
    Lift Over Worst Offer Automatic Automatic
    Lift Over Control Group Automatic Automatic
  5. Configure the aggregation as follows for the following Offer Level Counts query items.
    Table 3. Aggregate functions for Offer Level Counts query items

    This three-columned table provides the query items in one column, the aggregate functions in the second column, and the rollup aggregate functions in the third column.
    Query item Aggregate Function Rollup Aggregate Function
    Number of Offers Given-Offer None Automatic
    Unique Responders-Offer None Automatic
    Not Contacted Responders-Offer None Automatic
    Responses after Expiration-Offer None Automatic
    Unique Responders Control Group-Offer None Automatic
  6. Change the expression for the Response Transactions-Offer query item to be the following.
    [Offer Performance Summary].[Offer Response History Summary].
	[Response Transactions] / count([Campaign Name] for [Offer ID])
  7. Configure the aggregation as follows for the following Offer Level Counts query items.
    Table 4. Aggregate functions for Offer Level Counts query items

    This three-columned table provides the query items in one column, the aggregate functions in the second column, and the rollup aggregate functions in the third column.
    Query item Aggregate Function Rollup Aggregate Function
    Response Transactions - Offer Total Automatic
    Unique Recipients - Offer Total Automatic
    Unique Recipients Control Group - Offer Total Automatic
  8. Configure the aggregation as follows for the following Offer Level Counts query items.
    Table 5. Aggregate functions for Offer Level Counts query items

    This three-columned table provides the query items in one column, the aggregate functions in the second column, and the rollup aggregate functions in the third column.
    Query item Aggregate Function Rollup Aggregate Function
    Response Rate - Offer Automatic Automatic
    Responder Rate - Offer Automatic Automatic
    Responder Rate Control Group - Offer Automatic Automatic
    Lift Over Control Group - Offer Automatic Automatic
  9. For the Report Total level counts, change the expression for Total Response Transactions to be the following.

    total ([Response Transactions-Offer])

  10. Also, for Total Response Transactions, confirm that Aggregate Function is set to Automatic and that Rollup Aggregate Function is set to Automatic.
  11. Lock the report.
  12. 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.
  13. Save and run the report.