To create a Campaign Offer Response Breakout schema
1.
Select Settings > Configuration and expand Reports > Schemas > Campaign > Campaign Offer Response Breakout Star Schema.
2.
Click New category name and enter a descriptive name for the reporting schema that indicates the audience level. For example, Campaign Offer Response Household.
3.
In the Input Tables section, enter the name of the response history table for this audience level, and then click Save Changes.
A new node appears in the Configuration tree for the schema. You cannot change the name of the node.
4.
Under the new node, select Columns > Response Type and then configure the response types for this audience level.
For help with this step, see the procedure Adding response types.
5.
Under the new node, select SQL Configuration > Campaign Response Breakout and click Edit Settings.
6.
In the form that appears, edit the name in the Table/View Name field to include the code for the audience level. The name can be no longer than 18 characters and must be in all UPPERCASE letters.
For example, if the name of the audience level is household, you might specify: UARC_CRBO_HH_. For more information about table and view naming conventions, see the Reports | Schemas | [product] | [schema name] | SQL Configuration.
7.
Click Save Changes.
8.
Under the new node, select SQL Configuration > Campaign Offer Response Breakout and click Edit Settings.
9.
Edit the name in the Table/View Name field to include the code for the audience level. The name can be no longer than 18 characters and must be in all UPPERCASE letters.
For example, UARC_CORBO_HH_.
10.
Click Save Changes.
Copyright IBM Corporation 2014. All Rights Reserved.