1.
|
Select Settings > Configuration and expand Reports > Schemas > Interact > Interact Performance Star Schema.
|
2.
|
In the New category name field, enter a descriptive name for the reporting schema that indicates the audience level. For example, Interact Performance Household.
|
3.
|
In the Input Tables section, identify the tables that support the audience level and the audience key.
|
4.
|
In the Schema Settings section, select all the Over Time Variations options that apply and then click Save Changes.
|
5.
|
Under the new node, select SQL Configuration and select the first item, Interactive Channel Offer Contact History Summary.
|
6.
|
In the form that appears, edit the value 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.
|
7.
|
8.
|
Repeat steps 6 and 7 for each item listed under the SQL Configuration section of the new reporting schema.
|
Copyright IBM Corporation 2012. All Rights Reserved.
|