Use Interact Performance Star Schema to
create Interact Performance Schema.
About this task
Complete the following steps to create an Interact Performance
schema
Procedure
- Select Settings > Configuration and
expand Reports > Schemas > Interact > Interact Performance
Star Schema.
- In the New category name field,
enter a descriptive name for the reporting schema that indicates
the audience level.
For example, Interact
Performance Household.
- In the Input Tables section, identify
the tables that support the audience level and the audience
key.
- In the Schema Settings section,
select all the Over Time Variations options
that apply and then click Save Changes.
A new node appears in the Configuration tree for the
schema. You cannot change the name of the node.
- Under the new node, select SQL Configuration and
select the first item, Interactive Channel Offer Contact History
Summary.
- 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.
For example, if the
name of the audience level is household, you might specify:
UARI_ICP_OCH_HH_.
- Click Save Changes.
- Repeat steps 6 and 7 for each item that is listed under
the SQL Configuration section of the
new reporting schema.