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

[Former Member]

Hi Eyal,

maybe I do not understand the example but in your rules you're using different accounts from the written above (199 and 299), are you sure these have the right acc_type? How are these accounts connected with the other?

Regards

     Roberto

[Eyal_Feiler]

Hi Roberto,

199 is the parent Asset Account and 299 Liab & Equity (I know the numbering is confusing).

When I run the validation with TC_NONE I_NONE and M_NONE the rule works as expected.  The data set is fine.

The validation rule is splitting the rule by dimension member - in the balanced sheet is balancd rule it's checking by Migzar and TC member separately. 

It should select it all unless restricted in the source.

Regards,

Eyal

[Former Member]

Hi Eyal,

have you tried inserting the used Migzar and TC member values in the "other source dimensions members" ?

Regards

     Roberto

[Eyal_Feiler]

Hi Roberto,

If I select one value it works e.g. TC_NONE or (create a new TC_VALD).

TC_NONE and MIGZAR_NONE and I_NONE - string selects but just those values.

We have many values for each dimension. 

I tried the parents - one at a time and together - e.g. TC_ALL.  Result = 0 selected.

OSS says we can only select base members.  - Understand but then how can validation rules be used to check data with multiple dimensions?

Thanks

Eyal