Guidelines for creating a data mart report for predictive analysis

Before creating a data mart for the predictive model, ensure that the attributes and metrics used in the data mart report can also be used as inputs to the predictive metric. The following guidelines are meant as an overview. For more information on these guidelines, see the Advanced Reporting Help.

Make sure the data mart report has only one attribute (or one set of related attributes) in the rows, and only metrics in the columns.
The attributes on the rows of the dataset control the level, or dimensionality, of the dataset report. If a metric is used in the predictive model without a level, the metric results change based on the attributes of the report using the predictive metric. Creating a level metric for the predictive metric, which sets the metric level, can resolve this problem. For directions, see Level metrics as inputs for predictive metrics.
To group the results of a metric by an attribute, create a filtered metric for each attribute element. For directions, see Conditional metrics as inputs for predictive metrics.
Set the attribute join type for the report. Setting the attribute join type ensures that any missing data does not cause rows to be deleted. Set the attribute join type of the report to either of the following:
Preserve lookup table elements joined to the final pass result table based on the template attributes with filter keeps all attribute elements and applies all related filtering conditions.
Preserve lookup table elements joined to the final pass result table based on the template attributes without filter keeps all attribute elements and ignores all related filtering conditions.
- For more information, see Report Data Options dialog box: Attribute Join Type.
A metric condition is essentially a filter that allows an attribute to qualify metrics. For example, you can display customer revenue by payment method. For more information, see Conditional metrics as inputs for predictive metrics.

Once you have met these guidelines, you are ready to create the data mart.