BPC Member formula - performance issue
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.
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
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