Fixing the single object Offer Performance Summary by Campaign report

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

Procedure

Complete the following steps 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 given in the following table for the 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 given in the following table for 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 given in the following table for 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 given in the following table for 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 given in the following table for 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. Lock the report.
  10. Complete the following tasks 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.