Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

BPC Member formula - performance issue

Dear All

we are using BPC10 NW. In that we have almost 25 member formulas. Each member formula refers to function in script logic.

my query is

1. Is member formula advisable? as it may cause performance issue

2. Since the member formulas inturn referring to script logic, does it causes heavy performance issue? like when we input or refresh a single cell its taking long time.

Please advise.

If member formulas can cause this performance issues, what could be alternate way?

Can it be thru script logic for all the calculation mentioned in formula

? If we go with script logic, it will write the data into Database which increases load in dB. please advise.

Second thing is..

we have hierarchy like this

A ----> Parent1

           B------->Base member   --- Member formula is C*D for example

           C----->base members

           D------>base member

when we do reporting on A, we could see aggregation of C and D alone but not the value of B.

Is it the standard behavior that parent member wont aggregate base member containing formula

Please advise

thanks

Tags:
replied

It's not possible to write to the parents. But on the report with parents you will have incorrect results due to aggregation of base members. Users will be happy to see year total ratio as a sum  of months ratios

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question