on 02-17-2015 11:03 AM
Hi
I have created script logic to post zero's and created a Datamanager packages to run this logic. I want to hardcode dimension members when running this package.
Used INFO %SUFFIX1% in DM modify script but when ran this package getting ERROR message "Invalidate selection condition"
INFO(%SUFFIX1%,DIMENSION:CATEGORY|ACTUAL|)
INFO(%SUFFIX2%,DIMENSION:AUDITID|PLAN|)
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%%SUFFIX1%%SUFFIX2%)
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,LOGICFILENAME,CLEAR_AACT.LGF)
Did I missing any thing ?
Using the instructions in this document http://scn.sap.com/docs/DOC-34892 to hardcode dimension members.
Thank you
Best Regards
Jack
Something like:
INFO(%PREFIX%,@@@SAVE@@@@@@EXPAND@@@|)
INFO(%SUFFIX1%,DIMENSION:CATEGORY|ACTUAL|)
INFO(%SUFFIX2%,DIMENSION:AUDITID|PLAN|)
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,%PREFIX%%SUFFIX1%%SUFFIX2%)
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,LOGICFILENAME,CLEAR_AACT.LGF)
Or you can directly combine prefix and suffixes in single line
Vadim
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Jack,
%SELECTION% variable has specific format. If you don't fill %SELECTION% with some PROMPT(SELECTINPUT... you have to construct the full format, not only suffix part!
Vadim
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 | |
3 | |
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.