Skip to Content
0
Dec 13, 2015 at 07:27 AM

Multiple level consolidation on SAP BPC 10.1 NW

290 Views

Dear experts,

I am facing an issue that I am not able to solve in SAP BPC 10.1 Nw.

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 a lot for your help

Best regards

Andrea

Attachments

Immagine1.png (14.9 kB)
Immagine2.png (10.3 kB)