Skip to Content
avatar image
Former Member

Nested calculation of Accounts in Script logic

Dear Experts,

I have some problems with nested accounts in BPC. We are implementing BPC NW 10.0. As I know, in member formulas nested rules / calculation are not possible, so we tried to make the calculation with script logic. But here it takes me just the base members and calculatet it, but not the calculated accounts. We have the calculations in the consolidation model for the accounts.

For example, we would have some calculations on nested accounts:

First step:

Amount of Account 124200 with F14 and F16 should be write on Account CF162000

Second step:

Amount of Account CF161000 + CF162000 should be write on Account CF160000

First step calculation works well but the second step ist not working.

We wrote the following logic script but it does not work well:

*XDIM_MEMBERSET ACCOUNT=1242000
*XDIM_ADDMEMBERSET ACCOUNT=1242000
*WHEN ACCOUNT
*IS 1242000
*WHEN MOVEMENTTYPE
*IS F14,F16
*REC(FACTOR=-1,ACCOUNT=CF162000,MOVEMENTTYPE=END)
*ENDWHEN
*ENDWHEN

*XDIM_MEMBERSET ACCOUNT=1241000,1243000,1261000,1262000,1263000,1264000
*XDIM_ADDMEMBERSET ACCOUNT=1241000,1243000,1261000,1262000,1263000,1264000
*WHEN ACCOUNT
*IS 1241000,1243000,1261000,1262000,1263000,1264000
*WHEN MOVEMENTTYPE
*IS F14,F16
*REC(FACTOR=-1,ACCOUNT=CF161000,MOVEMENTTYPE=END)
*ENDWHEN
*ENDWHEN

*XDIM_MEMBERSET ACCOUNT=1281000,1282000,1283000,1284000,1285000
*XDIM_ADDMEMBERSET ACCOUNT=1281000,1282000,1283000,1284000,1285000
*WHEN ACCOUNT
*IS 1281000,1282000,1283000,1284000,1285000
*WHEN MOVEMENTTYPE
*IS F14,F16
*REC(FACTOR=-1,ACCOUNT=CF163000,MOVEMENTTYPE=END)
*ENDWHEN
*ENDWHEN
*COMMIT

*XDIM_MEMBERSET ACCOUNT=CF161000,CF162000,CF163000
*WHEN ACCOUNT
*IS CF161000,CF162000,CF163000
*WHEN MOVEMENTTYPE
*IS END
*REC(FACTOR=1,ACCOUNT=CF160000,MOVEMENTTYPE=END)
*ENDWHEN
*ENDWHEN
*COMMIT

Is here something wrong why it does not work correctly. We would like to make the calcualtion in multipe periods of a year.

Hope someone of you have a solution for this promlem.

Thanks

Daniel

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Nov 03, 2016 at 11:12 AM

    First of all dimension member formulas and script logic are absolutely different tools, you can't use one instead of another. And if you have hana you can use nested dimension formulas.

    For script logic please explain what you want to achieve in line with: https://blogs.sap.com/2014/01/31/how-to-ask-questions-about-script-logic-issues/

    Add comment
    10|10000 characters needed characters exceeded