How to aggregate calculated base member at parent GL in BPC

[former_member590808]

Hi

We have a parent GL PMTR_B00001 which has base elements as TB_B0001 + TB_B0002. TB_B0001 has a calculated value which is summation of 2 GLs being done via a member formula.

When I check the value at PMTR_B00001 it just shows me data at TB_B0002, value of TB_B0001 is not getting aggregated. I have read on a forum that calculated members don't get aggregated at Parent GL so what can be an alternative to this ? I cannot handle it in script because that would require executing a package etc. Is there any other way that this case can be handled ?

Regards

[former_member186338 · Accepted solution]

Parent will never aggregate calculated members!

[former_member186338]

"I have read on a forum that calculated members don't get aggregated at Parent GL so what can be an alternative to this ?" - Correct!

You can create another calculated member with member formula:

TB_B0002+TB_B000x+TB_B000y

[Pawan_Mahto]

But the parent GL PMTR_B00001 will not show the summed value right ? We want the parent GL should have the aggregated amount. Is that possible