on 09-28-2017 5:13 PM
Hi guys,
I created the following advanced script logic:
PROMPT(SELECTINPUT,,,,"%CATEGORY_DIM%,%CURRENCY_DIM%,%TIME_ DIM%,%DATASRC_DIM%,%ENTITY_DIM%,RB_PRODUCT,RB_SALESGRP")
PROMPT(TEXT,%Z_INCREASE_REV%,"Input Revenue Increase in Percent",)
INFO(%EQU%,=)
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,SUSER,%USER%)
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,SAPPSET,%APPSET%)
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,SAPP,%APP%)
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,SELECTION,%SELECTION%)
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,LOGICFILENAME,REVALUE_PLAN.LGF)
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,REPLACEPARAM,Z_INCREASE_REV%EQU%%Z_INCREASE_REV%)
<br>
When i run it , i have the follwoing error:
How can i correct it?
Thanks.
Amine
Instead of MDX formula WHEN/REC/ENDWHEN is recommended:
*XDIM_MEMBERSET RB_ACCOUNT=410000
*XDIM_MEMBERSET RB_CATEGORY=Plan
*WHEN RB_ACCOUNT
*IS * //already scoped
*REC(EXPRESSION=%VALUE%*(1+$Z_INCREASE_REV$/100))
*ENDWHEN
And please check the chain for DM package!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Try to re-activate environment shell by the followings steps
See more details on KBA
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Amine,
Why you didn't use the delivered Process Chain? How did you create you Process Chain? I'd need to see technical names of each Process Type to tell you why you are getting this error.
Regards,
Gersh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Gersh,
The issue is absolutely clear, the topic author used created the custom process chain to launch a script logic 🙂 And in the advanced script he used statements for standard chain: DEFAULT_FORMULAS.
Please look on my answers.
Hi Vadim,
It's fine using statements for DEFAULT_FORMULAS in custom chain as long as Variants have same names and same sets of parameters. That's why I asked how he created that PC: copy or manual, with variants or without, etc.
BR
Thanks a lot guys.
Amine
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You don't need to create a new chain to launch script logic file! Absolutely useless! (It was required in the old days of BPC NW 7.0! Even in 7.5 you don't need to do it).
Use standard chain: DEFAULT_FORMULAS
P.S. Before using some document first check for what BPC version it was created 🙂
No surprise! A lot of books contain just a copy paste information without checking...
Have to repeat - there is ABSOLUTELY no reason to create custom chain to launch script logic for BPC 7.5, 10 and 10.1.
Standard chain /CPMB/DEFAULT_FORMULAS can be used (or any other chain developed to run script logic like:
/CPMB/ALLOCATION
/CPMB/FX_RESTATEMENT
etc.
And the error you have is due to the fact that for custom chain you are using advanced script statements for the standard chain /CPMB/DEFAULT_FORMULAS:
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,SUSER,%USER%)
P.S. Can you provide some details about this book - book name and author?
Hi Vadim,
This one:
https://www.sap-press.com/sap-business-planning-and-consolidation_3770/
Can you advice me a better book please to understand BPC?
Thanks.
Amine
I have no idea 🙂 I am reading SAP help, Community blogs and discussions and SAP notes.
Never read books about BPC...
I suspect that the authors of this book Kumar Srinivasan and Sridhar Srinivasan simply copy pasted the information from: https://archive.sap.com/documents/docs/DOC-4159
And this document is relevant only for BPC NW 7.0 🙂
As I already told you I don't know any tutorial free from errors.
There are errors even in the original SAP help for BPC 🙂
And in some cases the new functions are described only in SAP notes...
Simply read more articles and compare information. Search Community forum. Ask questions.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Sorry, but do you understand that your question is unreadable????????????????
Do you look on on your post results?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
15 | |
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.