Skip to Content
0
Former Member
May 12, 2008 at 05:11 PM

Defining sub-group with Ownership application

34 Views

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