Installation and Configuration Guide

10.1 HotFix 1
- 10.1

Back Next

User-Defined Default Rules

You can define default rules to identify a single preferred record when the row rules return multiple records or to identify a single preferred column value when a column rule returns multiple values. If you do not define default rules, the consolidation process uses the system-defined default rules.

You can configure a name for each user-defined rule and set the rule type and execution order. The consolidation process runs the rules based on the execution order until the consolidation process selects a single preferred record or column value.

You can use the following user-defined default rules:

LATEST_TIMESTAMP

DEFAULT_RULE_MAX_COLUMN_VALUES

The following sample lists the LATEST_TIMESTAMP and DEFAULT_RULE_MAX_COLUMN_VALUES rules:

<DefaultRules>
   <DefaultRule name="defaultRule1" rule="LATEST_TIMESTAMP" order="1">
      <ReferenceColumn columnName="Date&Time" />
   </DefaultRule>
   <DefaultRule name="defaultRule2" rule="DEFAULT_RULE_MAX_COLUMN_VALUES" order="2">
      <Value columnValue="ID" weight="2" />
      <Value columnValue="SAP" weight="1" />
   </DefaultRule>
</DefaultRules>

Creating a Consolidation Rules File

LATEST_TIMESTAMP

DEFAULT_RULE_MAX_COLUMN_VALUES

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal