Compatibility Rules

When running the "change source", the following compatibility rules apply to avoid an inconsistent mapping:

  • Compatibility of the source and target object types (dimension, measure, attribute, hierarchy, and so on)
  • Compatibility of the source and target object data type (member, string, numeric, date, and so on)
  • Compatibility of the source and target object usage, if the object can be used as a result object, a filter object, or a sort object

These compatibility rules are defined through the qualificationTolerance and dataTypeTolerance <policy> attributes. They specify the tolerance to be considered when matching the source and target objects.

The following table shows the possible object matches according to the qualificationTolerance attribute value applied to the object type.

 

Target Dimension

Target Hierarchy

Target Level

Target Dimension Attribute

Target Measure Attribute

Target Measure

Target Others

Source Dimension

Low

Medium

Medium

Medium

Medium

High

High

Source Hierarchy

High

Low

High

High

High

High

High

Source Level

High

High

Low

High

High

High

High

Source Dimension Attribute

Medium

High

High

Low

High

High

High

Source Measure Attribute

Medium

High

High

High

Low

High

High

Source Measure

High

High

High

High

High

Low

High

Source Others

High

High

High

High

High

High

Low if the same, else High

Note Other object types are Filter, NamedSet, and Prompt.

The following table shows the possible object matches according to the dataTypeTolerance attribute value applied to the data type.

 

Target N/A

Target Member

Target Numeric

Target String

Target Time/Date

Target Others

Source N/A

Low

High

High

High

High

High

Source Member

High

Low

Medium

Medium

Medium

Medium

Source Numeric

High

Medium

Low

High

High

High

Source String

High

Medium

High

Low

High

High

Source Time/Date

High

Medium

High

High

Low if the same, else Medium

High

Source Others

High

Medium

High

High

High

Low if the same, else High

Note
  • N/A refers to the objects of type Filter and NamedSet, which do not have any data type.

  • Time/Date data types are Date, DateTime, Time, and CalendarDate.

  • Other data types are Blob, Boolean, DataUnknown, Currency, Null, Percent, Scientific, and LongText.