Custom BADI can be used in Member formula.

[former_member599409]

Hi,

I have a requirment to create very complex member formuals.  do not want to use logic script , only want to create them in Member formula only.

Is there any way ,we can call custom BADI in Member formuals area itself, so that formuals get calculated on fly.

We are using BPC 10 NW SP11

Thanks

Pavan

[former_member186338 · Accepted solution]

Hi Pavan,

Please read this document:

But I don't think it's a good method...

Vadim

[former_member200327]

Hi Pavan,

You don't need BADI to implement long and complex member formulas. Take a look at OSS Note 1968797 that describes in details how to do this.

Even though it's true that calculating formulas affects performance, BADIs, like write-back or SQE, are called every time you retrieve data or write data - filter limits it very insignificantly.

Member formulas are called only when this member is used in a report.

Hope this helps,

Gersh

[former_member599409]

Thanks Gersh,

I have created few of my formulas using this method. i am under impression that these formuals will also be called when data  being read by any report

If it is  confirm that these  formulas called only when  this member used in the report.

i will  not consider these member formulas while measuring performance of the report which is not used this member.

Thanks in advance

Regards

Pavan

[former_member186338]

Hi Pavan,

Member formulas are calculated ONLY if you have this member in the report. No effect if you don't have member with member formula on the particular report.

B.R. Vadim

[akos_beres]

Pavan,

here is another post from Vadim. This is not a BADI but might work better:

https://scn.sap.com/thread/3463627

We played around with this and it seems to be working fine.

Akos

[former_member599409]

Thank you Akos,

I have created few of my complex formulas using same method.

Pavan

[former_member190501]

Hi,

I don't think BADI will support under member formulas. More over if your logic is so complex then it will have -ve  impact to performance . Better to put this logic in either script or excel based.

Hope it helps..

regads,

Raju