Skip to Content
0

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

May 07, 2017 at 07:31 AM

65

avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Vadim Kalinin May 23, 2017 at 06:05 PM
0

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!

Share
10 |10000 characters needed characters left characters exceeded
Ashish Gupta May 24, 2017 at 06:44 AM
0

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?

Show 1 Share
10 |10000 characters needed characters left characters exceeded

The script is also bad in the scoping - using for/next is not a good idea.

It'd better to scope the required accounts and multiply by ASP-8...

0