Skip to Content

Multiply all account with one account member in script logic SAP BPC10.0

requirement is to multiply accounts with quantity . i have captured all prices in account dimension using members, i have one member quantity, i want to multiply all account members with this quantity member. kindly guide me , i am new in BPC. i have tried something but it gives me error. my script is..

*select(%ACT%,ID,Account,ACCTYPE=INC,EXP)
*XDIM_MEMBERSET ACCOUNT=%ACT%

*WHEN ACCOUNT
*IS ASP-8

*FOR %AC%=%ACT%

*REC(EXPRESSION =%VALUE%([ACCOUNT].[%AC%]), ACCOUNT=%AC%)
*NEXT

*ENDWHEN

any help would be much appreciable.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • May 23, 2017 at 06:05 PM

    First - please spend some time reading https://blogs.sap.com/2014/01/31/how-to-ask-questions-about-script-logic-issues/

    Then provide the required information.

    Your logic explanation is not clear:

    "i want to multiply all account members with this quantity member" - all including quantity member??

    Do you really want to store the result in the same place??? May be different audittrail member???

    P.S. Please remove secondary tag EPM Add-In for Excel - no relation to your question!

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 24, 2017 at 06:44 AM

    You have missed multiplication sign in REC statement. Correct *REC statement -

    *REC(EXPRESSION =%VALUE%*([ACCOUNT].[%AC%]), ACCOUNT=%AC%)

    Script will work as long as account ASP-8 is EXP or INC but the results may not be desired.

    1. Why are you selecting all exp/inc accounts. Do you really want to perform calc for all of them? Instead, find a better way to select all your 'price' records in a variable and scope this variable along with ASP-8 account.

    2. What's the thing about doing some calculation and storing the calculation in the same account?

    Add comment
    10|10000 characters needed characters exceeded