Multiple level consolidation

[jamie111]

Dear experts,

I am facing an issue that I am not able to solve.

in my group I have an holding (let's call it C) that consolidates 2 entities. then we have the main holding (let's call it A) that consolidates C + other entities.

The problem is that Group A doesn't want to see Holding C and Entity B in it's consolidation: Group A wants to see the consolidated result of Group C.

I tried a first solution, wich is to store the result of Group C consolidation in a dummy entity (called CONSO_C) and then put CONSO_C into Group A consolidation.

this solution seems to work, but the problem is regarding IC eliminations.

Since Entity B and Holding C are no longer under Group A, their IC movements are not eliminated in Group A, which is not correct (e.g. Entity D has a credit towards Entity B --> this is not eliminated).

Do you have any suggestion? have you faced the same problem before?

Thanks

[jamie111]

Dear Vadim

Thank your solution, I think it will work.

Does the BPC provide the standard function to achieve the consolidation by level. And the "stage_only=Y" of the dimension Scope can help with it?

Thanks.

[former_member186338]

No, BPC standard approach is to perform consolidation from base entities. And it's fine! "Group A doesn't want to see Holding C and Entity B in it's consolidation" - this is strange...

[former_member186338]

For sure you can reclass INTCO, but requirement looks strange...

[jamie111]

Dear Vadim

I think the requirement is very common in the manual consolidation mode. What is the reclass logic for the dimension INTERCO? Actually consolidation ownership has multiple level.

Thanks.

TJ

[former_member186338]

"I tried a first solution, wich is to store the result of Group C consolidation in a dummy entity (called CONSO_C) and then put CONSO_C into Group A consolidation." - and what about INTCO for CONSO_C?