External Hier - Duplicated Values

Hy Gurus,

I have created an External Hier with Cost Center (like External CH) and Cost Element (like leaf of the hier). The problem is that in BEx values are replicated for every node, not considering Cost Center detail. Example:

CC: 1000 Amount = 6000

CE: ABCD Amount = 1000

CE: EFGH Amount = 5000

CC: 1100 Amount = 6000

CE: ABCD Amount = 1000

CE: EFGH Amount = 5000

Instead of:

CC: 1000 Amount = 3400

CE: ABCD Amount = 400

CE: EFGH Amount = 3000

CC: 1100 Amount = 2600

CE: ABCD Amount = 600

CE: EFGH Amount = 2000

How can I solve this problem ?

Thank you in advance and I will reward points.

I you need more info please send me an e-mail I will send you printscreen of the BEx.

Ciao.

Riccardo.

Message was edited by: Riccardo Venturini

Message was edited by: Riccardo Venturini