BPC 10 NW: How to use nested formulas?

[Former Member]

Hi BPC experts!

How can I use nested formulas in BPC 10 NW?

For example:

Account A = Account B + Account C

Account D = Account A + Account C

Does solve_order works in BPC 10?

How can I use it?

[esjewett]

I do not believe using "nested" formulas is possible. It certainly was not in the 7.5 version. I strongly recommend using script logic or business rules to derive your values and store them in base members.

"SOLVE_ORDER" refers to something else entirely: The evaluation order of formulas when formulas on different dimensions conflict.

Cheers,

Ethan

[Former Member]

Hi There

Do you wish to use the formulas in script logic or in dimension formula's

[http://help.sap.com/saphelp_bpc10_nw/helpdata/en/4c/3378c335c520d4e10000000a42189b/frameset.htm]

Kind Regards

Daniel

[Former Member]

I wish to use it in dimension formula's. Is it possible in BPC 10 Administration tool?

[former_member190501]

Hi,

Yes! it is possible in BPC 10 .

http://help.sap.com/saphelp_bpc10_nw/helpdata/en/4c/33764235c520d4e10000000a42189b/content.htm

You can view the member formulas added to a dimension by selecting Rules Member Formulas , then choosing the name of a dimension.

You can view the member formulas added to a dimension by selecting Rules Member Formulas , then choosing the name of a dimension.

You can add a formula to a dimension, as well as edit and delete a formula assigned to a dimension.

Thanks,

Raju