Hello,
I'd like to set up this consolidation :
1st group :
C_NEZONE (dimension « Groups » entity = NEZONE)
|____USA
|____japan
2cd group :
C_EZONE (dimension « Groups » entity = EZONE)
|____France
|____Italy
And I finaly need a consolidation to C_CGGROUP
C_CGGROUP
|____C_NEZONE (partially owned by C_CGGROUP : proportional method)
|____C_EZONE
As
1 - C_NEZONE and C_EZONE are,of course, members of the "Groups" dimension, it's not possible to attach them as child of C_CGROUP.
2 - The consolidation engine calculation, generates only values on the entity members concerned by the consolidation process (France, Italy...) and not on the "parent" members (EZONE or NEZONE in my example).
How can I set up thas kind of consolidation ? Using the PARENT_GROUP property of the groups dimension can only perform a 100% consolidation.
Thank you