on 05-07-2017 8:31 AM
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.
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
14 | |
4 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.