Skip to Content
0

Filter Datasrc used in BPC CONSOLIDATION based on Consolidation Group

Nov 30, 2016 at 05:57 PM

57

avatar image

Hi experts,

I'm running consolidation for 2 diferente groups. Any of those groups is using diferente Automatic Adjustments BR. We are fine here. We filter our business rules with a property on the datasrc as well as in groups dimension.

On Automatic Adjustment table:

Datasrc of sourse of data: Using DATASRC properties (dimlist y dimlist2) for each consolidation.
Filter by Group type: Using Group dimension property Conso_type

Everything is working fine regarding eliminations and the Business rules are taking one datasrc or another base on those properties, but the problem is the data which is not calculated. Data which is going from No_Group to Group directly in the consolidation.

This means data on datasrcs set as Datasrc_Type = M.

We created two datasrc for manual adjustments, one for each group of consolidation. For the calculation in the Business Rules is fine (as i expleined before, the filter on the BR is working correctly), but when the system move this data from No_Group to the expecific group, I can't find the way of filtering, so it moves both adjustments.

Here an example:

Datasrc NO_GROUP GROUP A GROUP B

INPUT 100 100 100
ADJ A 200 200 200
ADJ B 300 300 300
ELIM -300 -400

So, elimination is taking Adj A or Adj B base on the group as it has been defined on the BR (Elimination for Group A is taking Input and Adj A: 100+200, and so it happends in Group B), but the adjustment itseft is going to everygroup, no matter what.
I need the Adj A not flowing in Group B consolidation (200) and Adj B not flowing int Group A consolidation (300).

Any idea?

Thanks a lot!

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers