BPC member formula aggregating parent value

[former_member590808]

Hi

We have FX which is the parent element for SF01 and SF02.

SF01 and SF02 are getting calculated via member formula .

Let's suppose each has value 100. So at FX the aggregated value needs to appear as 200 but when am fetching the parent element in the report , it shows value as 400 : It splits 100+ 100 and 200 of self and shows 400 which is incorrect. I want to avoid this and want the element to display 200. Is there any setting which needs to change ?

Regards,

Neha

[former_member186338]

Can you show dimension member formulas?

BPC version/SP?

[former_member186338 · Accepted solution]

Sample on the system without HANA:

Formulas:

Dimension:

Report result:

[former_member186338]

On old BPC versions you have to duplicate member formulas of SF01 and SF02 in FX.

On HANA you can use [SF01]+[SF02]

https://help.sap.com/viewer/a2049170bfeb4178ace32222842c3ec1/10.1/en-US/457e4c2f471e4bb093d0233c5a02...

[former_member590808]

But FX is the parent member of F01 and F02. How can I define a formula on parent member ? Also if I go by this approach will I have to create this formula for all the parent entities I have ?

[former_member186338]

nehayadav0911

Sorry, but parents do not aggregate members with dimension member formulas! You can't use aggregation for members with dimension member formulas.

If you need sum of 2 members with dimension member formulas - look on my answer.