Community
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results forĀ 
Search instead forĀ 
Did you mean:Ā 
Read only

Advance Script - Invalid Command selection issue

Go to solution
Former Member

on ā€Ž2016 Jul 18 8:06 PM

0 Likes
801

Hello Expert ,

I am trying to run below advance script through DM package but its throwing error

" Invalid Data selection command "

Requirement is User will only select cal month which I have make it as different prompt for  depreciation calculation. There is script logic where its calling BADI in backend

Running the same script logic for one prompt is working fine but with 2 prompt its throwing error.

Could you please help me for the same.

PROMPT(SELECTINPUT ,,,,"%ACOUNT_PS,AUDITTRAIL,COMPANY,COSTCENTER,EVENT,INTERCO,PROFITCENTER,PROJECT,RPTCURRENCY,TIME,VARIANCEDETAIL%")

PROMPT(SELECTINPUT,"%CALCMONTH%,,"CALC MONTH","%TIME_DIM%")

INFO(%EQU%,=)

INFO(%TAB%,,;)

CPMB/DEFAULT_FORMULAS_LOGIC,EQU,%EQU%)

CPMB/DEFAULT_FORMULAS_LOGIC,TAB,%TAB%)

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,MEMBERSELECTION,CALCMONTH%EQU%%CALCMONTH%)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,LOGICFILENAME,EDD656.LGF)

Know the answer?

Help others by sharing your knowledge.

Answer

Need more details?

Request clarification before answering.

Show replies
Show replies

Accepted Solutions (1)

Accepted Solutions (1)

former_member186338
Active Contributor
ā€Ž2016 Jul 18 8:33 PM
0 Likes

Incorrect syntax - not:

PROMPT(SELECTINPUT ,,,,"%ACOUNT_PS,AUDITTRAIL,COMPANY,COSTCENTER,EVENT,INTERCO,PROFITCENTER,PROJECT,RPTCURRENCY,TIME,VARIANCEDETAIL%")

But:

PROMPT(SELECTINPUT ,,,,"ACOUNT_PS,AUDITTRAIL,COMPANY,COSTCENTER,EVENT,INTERCO,PROFITCENTER,PROJECT,RPTCURRENCY,TIME,VARIANCEDETAIL")

No %%!

Show replies
Show replies
former_member186338
Active Contributor
ā€Ž2016 Jul 18 8:35 PM
0 Likes

Also TIME dimension is selected twice:

PROMPT(SELECTINPUT ,,,,"ACOUNT_PS,AUDITTRAIL,...,TIME,VARIANCEDETAIL")

And

PROMPT(SELECTINPUT,"%CALCMONTH%,,"CALC MONTH","%TIME_DIM%")

Former Member
ā€Ž2016 Jul 18 8:41 PM
0 Likes

Still its throwing error " Invalid Selection Command " After removing % in first prompt

former_member186338
Active Contributor
ā€Ž2016 Jul 18 8:46 PM
0 Likes

Ups, extra space in the line! Have to be removed:

PROMPT(SELECTINPUT,,,,"ACOUNT_PS,AUDITTRAIL,COMPANY,COSTCENTER,EVENT,INTERCO,PROFITCENTER,PROJECT,RPTCURRENCY,TIME,VARIANCEDETAIL")

And the list ACOUNT_PS,AUDITTRAIL,COMPANY,COSTCENTER,EVENT,INTERCO,PROFITCENTER,PROJECT,RPTCURRENCY,TIME,VARIANCEDETAIL has to contain real dimensions names!

former_member186338
Active Contributor
ā€Ž2016 Jul 18 8:48 PM
0 Likes

Also incorrect lines:

CPMB/DEFAULT_FORMULAS_LOGIC,EQU,%EQU%)

CPMB/DEFAULT_FORMULAS_LOGIC,TAB,%TAB%)

Has to be:

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,EQU,%EQU%)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,TAB,%TAB%)

Please be accurate!

former_member186338
Active Contributor
ā€Ž2016 Jul 18 8:50 PM
0 Likes

Also incorrect:

INFO(%TAB%,,;)

Has to be:

INFO(%TAB%,;)

Answers (4)

Answers (4)

Former Member
ā€Ž2016 Jul 18 9:05 PM
0 Likes

PROMPT(SELECTINPUT ,,,,"ACOUNT_PS,AUDITTRAIL,COMPANY,COSTCENTER,EVENT,INTERCO,PROFITCENTER,PROJECT,RPTCURRENCY,TIME,VARIANCEDETAIL")

PROMPT(SELECTINPUT,"%CALCMONTH%,,"CALC MONTH","%TIME_DIM%")

INFO(%EQU%,=)

INFO(%TAB%,;)

TASK(CPMB/DEFAULT_FORMULAS_LOGIC,EQU,%EQU%)

TASK(CPMB/DEFAULT_FORMULAS_LOGIC,TAB,%TAB%)

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,MEMBERSELECTION,CALCMONTH%EQU%%CALCMONTH%)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,LOGICFILENAME,EDD656.LGF)

Show replies
Show replies
former_member186338
Active Contributor
ā€Ž2016 Jul 18 9:09 PM
0 Likes

Incorrect space is still here

Duplicate TIME is here

CPMB without / is here

You are not correcting errors!

Sorry, but I can't help you...

The correct script:

PROMPT(SELECTINPUT,,,,"ACOUNT_PS,AUDITTRAIL,COMPANY,COSTCENTER,EVENT,INTERCO,PROFITCENTER,PROJECT,RPTCURRENCY,VARIANCEDETAIL")

PROMPT(SELECTINPUT,"%CALCMONTH%,,"CALC MONTH","%TIME_DIM%")

INFO(%EQU%,=)

INFO(%TAB%,;)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,EQU,%EQU%)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,TAB,%TAB%)

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,MEMBERSELECTION,CALCMONTH%EQU%%CALCMONTH%)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,LOGICFILENAME,EDD656.LGF)

Former Member
ā€Ž2016 Jul 18 9:14 PM
0 Likes

could you please help me with where you are poiting about duplicate TIME and CPMP / ?

former_member186338
Active Contributor
ā€Ž2016 Jul 18 9:16 PM
0 Likes

Please compare yourself!

In my previous message I have posted the script without errors! Compare each character

Former Member
ā€Ž2016 Jul 18 9:17 PM
0 Likes

could you please help me with where you are poiting about duplicate TIME and CPMB without /?

former_member186338
Active Contributor
ā€Ž2016 Jul 18 9:18 PM
0 Likes

Ups even one extra error:

Not:

PROMPT(SELECTINPUT,"%CALCMONTH%,,"CALC MONTH","%TIME_DIM%")

But:

PROMPT(SELECTINPUT,%CALCMONTH%,,"CALC MONTH","%TIME_DIM%")

Remove " before %CALCMONTH%

former_member186338
Active Contributor
ā€Ž2016 Jul 18 9:21 PM
0 Likes

Compare each character yourself!

PROMPT(SELECTINPUT,,,,"ACOUNT_PS,AUDITTRAIL,COMPANY,COSTCENTER,EVENT,INTERCO,PROFITCENTER,PROJECT,RPTCURRENCY,VARIANCEDETAIL")

PROMPT(SELECTINPUT,%CALCMONTH%,,"CALC MONTH","%TIME_DIM%")

INFO(%EQU%,=)

INFO(%TAB%,;)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,EQU,%EQU%)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,TAB,%TAB%)

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,MEMBERSELECTION,CALCMONTH%EQU%%CALCMONTH%)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,LOGICFILENAME,EDD656.LGF)

Former Member
ā€Ž2016 Jul 18 9:24 PM
0 Likes

Corrected but still there is error .

Regarding TIME dimension its requirement to for selection parameter time value will be enter by another user or fixed  and second prompt TIME value will be used by another user for calculation

PROMPT(SELECTINPUT,,,,"ACOUNT_PS,AUDITTRAIL,COMPANY,COSTCENTER,EVENT,INTERCO,PROFITCENTER,PROJECT,RPTCURRENCY,TIME,VARIANCEDETAIL")

PROMPT(SELECTINPUT,"%CALCMONTH%,,"CALC MONTH","%TIME_DIM%")

INFO(%EQU%,=)

INFO(%TAB%,;)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,EQU,%EQU%)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,TAB,%TAB%)

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,MEMBERSELECTION,CALCMONTH%EQU%%CALCMONTH%)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,LOGICFILENAME,EDD656.LGF)

Former Member
ā€Ž2016 Jul 18 9:28 PM
0 Likes

Removed " in CALMONTH also

PROMPT(SELECTINPUT,,,,"ACOUNT_PS,AUDITTRAIL,COMPANY,COSTCENTER,EVENT,INTERCO,PROFITCENTER,PROJECT,RPTCURRENCY,TIME,VARIANCEDETAIL")

PROMPT(SELECTINPUT,%CALCMONTH%,,"CALC MONTH","%TIME_DIM%")

INFO(%EQU%,=)

INFO(%TAB%,;)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,EQU,%EQU%)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,TAB,%TAB%)

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,MEMBERSELECTION,CALCMONTH%EQU%%CALCMONTH%)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,LOGICFILENAME,EDD656.LGF)

former_member186338
Active Contributor
ā€Ž2016 Jul 18 9:30 PM
0 Likes

Ok, you are not reading my messages! Line PROMPT(SELECTINPUT,"%CALCMONTH%,,"CALC MONTH","%TIME_DIM%") is incorrect!

I had restored first TIME selection:

Copy paste the following code instead of your code and test:

PROMPT(SELECTINPUT,,,,"ACOUNT_PS,AUDITTRAIL,COMPANY,COSTCENTER,EVENT,INTERCO,PROFITCENTER,PROJECT,RPTCURRENCY,TIME,VARIANCEDETAIL")

PROMPT(SELECTINPUT,%CALCMONTH%,,"CALC MONTH","%TIME_DIM%")

INFO(%EQU%,=)

INFO(%TAB%,;)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,EQU,%EQU%)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,TAB,%TAB%)

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,MEMBERSELECTION,CALCMONTH%EQU%%CALCMONTH%)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,LOGICFILENAME,EDD656.LGF)

Former Member
ā€Ž2016 Jul 18 9:32 PM
0 Likes

copy paste your code also but still the same error " Invalid Selection Command "

former_member186338
Active Contributor
ā€Ž2016 Jul 18 9:34 PM
0 Likes

Copy paste this code!

What is the result?

former_member186338
Active Contributor
ā€Ž2016 Jul 18 9:35 PM
0 Likes

Show screenshot of the advanced script edit!

Former Member
ā€Ž2016 Jul 18 9:37 PM
0 Likes

NOw its showing dimension "ACCOUNT_PS"  not assign in DM package

former_member186338
Active Contributor
ā€Ž2016 Jul 18 9:39 PM
0 Likes

Screenshot!

Former Member
ā€Ž2016 Jul 18 9:39 PM
0 Likes

Due to client restriction can not attached snap shot but here I am copying editing code

PROMPT(SELECTINPUT,,,,"ACOUNT_PS,AUDITTRAIL,COMPANY,COSTCENTER,EVENT,INTERCO,PROFITCENTER,PROJECT,RPTCURRENCY,TIME,VARIANCEDETAIL")

PROMPT(SELECTINPUT,%CALCMONTH%,,"CALC MONTH","%TIME_DIM%")

INFO(%EQU%,=)

INFO(%TAB%,;)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,EQU,%EQU%)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,TAB,%TAB%)

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,MEMBERSELECTION,CALCMONTH%EQU%%CALCMONTH%)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,LOGICFILENAME,EDD656.LGF)

and error was "ACOUNT_PS" not assign in DM Package

former_member186338
Active Contributor
ā€Ž2016 Jul 18 9:40 PM
0 Likes

And another typo error!

PROMPT(SELECTINPUT,,,,"ACCOUNT_PS,AUDITTRAIL,COMPANY,COSTCENTER,EVENT,INTERCO,PROFITCENTER,PROJECT,RPTCURRENCY,TIME,VARIANCEDETAIL")

Instead of ACOUNT_PC has to be ACCOUNT_PS

former_member186338
Active Contributor
ā€Ž2016 Jul 18 9:45 PM
0 Likes

Please read my answers:

Not:

PROMPT(SELECTINPUT,,,,"ACOUNT_PS...

But

PROMPT(SELECTINPUT,,,,"ACCOUNT_PS

Unbelievable how many typo errors can be done!

Former Member
ā€Ž2016 Jul 18 9:48 PM
0 Likes

I just copied paste your code but yes by correcting it now its showing

" AUDITTRAIL " not assigned in Data Manager Package

former_member186338
Active Contributor
ā€Ž2016 Jul 18 9:51 PM
0 Likes

Sorry, but it's your error! I don't know the dimension names you have in the model!

Please check all dimension names!

Show the list

Former Member
ā€Ž2016 Jul 18 9:53 PM
0 Likes

Checking the same and now I will correct it.

Thanks ! Vadim šŸ™‚

Former Member
ā€Ž2016 Jul 18 9:56 PM
0 Likes

Corrected the Logic and code is working now . Yes agreed to many typo error I have made.

Thanks Vadim Again šŸ™‚

Former Member
ā€Ž2016 Jul 18 9:01 PM
0 Likes

checked everything no duplicate and no space issue

Show replies
Show replies
former_member186338
Active Contributor
ā€Ž2016 Jul 18 9:03 PM
0 Likes

Please copy and post the final version!

Former Member
ā€Ž2016 Jul 18 9:10 PM
0 Likes

PROMPT(SELECTINPUT ,,,,"ACOUNT_PS,AUDITTRAIL,COMPANY,COSTCENTER,EVENT,INTERCO,PROFITCENTER,PROJECT,RPTCURRENCY,TIME,VARIANCEDETAIL")

PROMPT(SELECTINPUT,"%CALCMONTH%,,"CALC MONTH","%TIME_DIM%")

INFO(%EQU%,=)

INFO(%TAB%,;)

TASK(CPMB/DEFAULT_FORMULAS_LOGIC,EQU,%EQU%)

TASK(CPMB/DEFAULT_FORMULAS_LOGIC,TAB,%TAB%)

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,MEMBERSELECTION,CALCMONTH%EQU%%CALCMONTH%)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,LOGICFILENAME,EDD656.LGF)

Former Member
ā€Ž2016 Jul 18 8:58 PM
0 Likes

corrected with INFO(%TAB%,;)  still throwing error

Show replies
Show replies
former_member186338
Active Contributor
ā€Ž2016 Jul 18 9:00 PM
0 Likes

Space?

Duplicate TIME?

former_member186338
Active Contributor
ā€Ž2016 Jul 18 9:02 PM
0 Likes

Not:

TASK(CPMB/DEFAULT_FORMULAS_LOGIC,EQU,%EQU%)

TASK(CPMB/DEFAULT_FORMULAS_LOGIC,TAB,%TAB%)

But:

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,EQU,%EQU%)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,TAB,%TAB%)

Do you see the difference?

Former Member
ā€Ž2016 Jul 18 8:53 PM
0 Likes

Yes it was typo

had written the same

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,EQU,%EQU%)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,TAB,%TAB%)

here is complete advance script and still its throwing error

PROMPT(SELECTINPUT ,,,,"ACOUNT_PS,AUDITTRAIL,COMPANY,COSTCENTER,EVENT,INTERCO,PROFITCENTER,PROJECT,RPTCURRENCY,TIME,VARIANCEDETAIL")

PROMPT(SELECTINPUT,"%CALCMONTH%,,"CALC MONTH","%TIME_DIM%")

INFO(%EQU%,=)

INFO(%TAB%,,;)

TASK(CPMB/DEFAULT_FORMULAS_LOGIC,EQU,%EQU%)

TASK(CPMB/DEFAULT_FORMULAS_LOGIC,TAB,%TAB%)

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,MEMBERSELECTION,CALCMONTH%EQU%%CALCMONTH%)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,LOGICFILENAME,EDD656.LGF)

Show replies
Show replies
former_member186338
Active Contributor
ā€Ž2016 Jul 18 8:56 PM
0 Likes

Still errors not corrected:

Duplicate TIME

Incorrect INFO(%TAB%

former_member186338
Active Contributor
ā€Ž2016 Jul 18 8:57 PM
0 Likes

Still space is present after SELECTINPUT!

Is it a joke?

Ask a Question