Controls (Validations) Filter By User Dimension

[Eyal_Feiler]

Hi Experts,

When running validations – the rule automatically filters and splits the result by the user defined dimensions.  In this case we have segment (called MIGZAR in the example).

So if an Entity imports

ENTITY ACCOUNT         TC        MIGZAR            AMOUNT          ACCT TYPE

1250     411_01  TC_USD           M_NONE          900             AST

1250     709       TC_NONE         M_NONE          -925                  LEQ

The result should be 900-925 = -25 but validation rule calculats 1825 (900+925).

ENTITY ACCOUNT         TC        MIGZAR            AMOUNT          ACCT TYPE

1270     411_01  TC_USD           M_NONE          900             AST

1270     411_01  TC_NONE         M_100              100                   AST

1270     709       TC_NONE         M_NONE          -925      L          EQ

Example 2 – the result is 900+100+925=1925.

Since each combination of dimensions are calculated separately TC and MIGZAR here.

Any ideas to correct or adjust?

Below is the system result and rule definition. Source filter purposely left blank.

Running 10.1 SP3

Regards,

  Eyal

[Eyal_Feiler · Accepted solution]

Roberto,

Figured it out.  On the destination fields - specify one field from each dimension:

TC=TC_NONE,MIGZAR=M_NONE,INTERCO=I_NONE

Obvious after we know the answer but tricky.