There are no predefined validations in this application template. This is due to the fact that the names for the EPM hierarchies are not fixed and the mapping validations are based on those hierarchy names.

This validation is intended to verify that all bottom (leaf) ERP nodes are mapped to an EPM hierarchy. The logic to fail the validation should be Core.Leaf = True AND Core.References does not contain EPM Hierarchy.

This can be done in multiple ways:

• Formula or script-based validation

• Query and a query-based validation

• Derived property and a property-based validation

Below is an example of a formula that could be used in a validation:

IF(AND(PropValue(core.leaf),Equals(integer,ArrayIndex(EPMHIERNAME,PropV alue(Core.References),[comma]),0)),True,False)

Where EPMHIERNAME is the actual EPM hierarchy name.