Skip to Content
avatar image
Former Member

BPC 10 NW: How to use nested formulas?

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Mar 02, 2012 at 08:47 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 01, 2012 at 02:49 PM

    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

    Add comment
    10|10000 characters needed characters exceeded