Prompts in DMP to be replaced with fixed values

[former_member493004]

Hello,

Product version: BPCNW 10.1 Classic.

BW :Release 751 and SP level 0002.

In the model Planning, we have dimensions TIME,VERSION,ACCOUNT,COMPANY_CODE to name few.

Script to be launched by Data Manager package.

Calculation Logic:- The flat file load to be given to user where user should be able to select only flat file and rest options should be automatically fed.

transformation file, merge/replace, Run default logic,check work status--> all these options want to fix once so that user do not have to again and again choose these.

Data Manger Advanced Script for Flat file upload below:- how to replace these prompts with some fixed values thats what i am looking for.

PROMPT(INFILES,,"Import file:",)
PROMPT(TRANSFORMATION,%TRANSFORMATION%,"Transformation file:",,,Import.xls)
PROMPT(RADIOBUTTON,%CLEARDATA%,"Select the method for importing the data from the source file to the destination database",0,{"Merge data values (Imports all records, leaving all remaining records in the destination intact)","Replace && clear datavalues (Clears the data values for any existing records that mirror each entity/category/time/datasource combination defined in the source, then imports the source records)"},{"0","1"})
PROMPT(RADIOBUTTON,%RUNLOGIC%,"Select whether to run default logic for stored values after importing",1,{"Yes","No"},{"1","0"})
PROMPT(RADIOBUTTON,%CHECKLCK%,"Select whether to check work status settings when importing data.",1,{"Yes, check for work status settings before importing","No, do not check work status settings"},{"1","0"})
PROMPT(KEYDATE,%KEYDATE%,"Key date",0)
INFO(%TEMPNO1%,%INCREASENO%)
INFO(%ACTNO%,%INCREASENO%)
INFO(%KEYDATE%,)
TASK(/CPMB/CONVERT,OUTPUTNO,%TEMPNO1%)
TASK(/CPMB/CONVERT,ACT_FILE_NO,%ACTNO%)
TASK(/CPMB/CONVERT,TRANSFORMATIONFILEPATH,%TRANSFORMATION%)
TASK(/CPMB/CONVERT,SUSER,%USER%)
TASK(/CPMB/CONVERT,SAPPSET,%APPSET%)
TASK(/CPMB/CONVERT,SAPP,%APP%)
TASK(/CPMB/CONVERT,FILE,%FILE%)
TASK(/CPMB/CONVERT,CLEARDATA,%CLEARDATA%)
TASK(/CPMB/CONVERT,KEYDATE,%KEYDATE%)
TASK(/CPMB/CLEAR_DATA,INPUTNO,%TEMPNO1%)
TASK(/CPMB/CLEAR_DATA,CHECKLCK,%CHECKLCK%)
TASK(/CPMB/CLEAR_DATA,KEYDATE,%KEYDATE%)
TASK(/CPMB/APPEND_LOAD,INPUTNO,%TEMPNO1%)
TASK(/CPMB/APPEND_LOAD,ACT_FILE_NO,%ACTNO%)
TASK(/CPMB/APPEND_LOAD,RUNLOGIC,%RUNLOGIC%)
TASK(/CPMB/APPEND_LOAD,CHECKLCK,%CHECKLCK%)
TASK(/CPMB/APPEND_LOAD,CLEARDATA,%CLEARDATA%)
TASK(/CPMB/APPEND_LOAD,KEYDATE,%KEYDATE%)

Can we do this in advanced script of Data Manager Package. if yes, how. can any one help me in this.

Thanks,

Ambika

[former_member186338 · Accepted solution]

Easy (sample):

PROMPT(INFILES,,"Import file:",)
INFO(%CLEARDATA%,0)
INFO(%RUNLOGIC%,0)
INFO(%CHECKLCK%,0)
INFO(%TEMPNO1%,%INCREASENO%)
INFO(%ACTNO%,%INCREASENO%)
INFO(%KEYDATE%,)
TASK(/CPMB/CONVERT,OUTPUTNO,%TEMPNO1%)
TASK(/CPMB/CONVERT,ACT_FILE_NO,%ACTNO%)
TASK(/CPMB/CONVERT,TRANSFORMATIONFILEPATH,\ROOT\WEBFOLDERS\%APPSET%\%APP%\DATAMANAGER\TRANSFORMATIONFILES\TRANSF_FILE_NAME.xls)
TASK(/CPMB/CONVERT,SUSER,%USER%)
TASK(/CPMB/CONVERT,SAPPSET,%APPSET%)
TASK(/CPMB/CONVERT,SAPP,%APP%)
TASK(/CPMB/CONVERT,FILE,%FILE%)
TASK(/CPMB/CONVERT,CLEARDATA,%CLEARDATA%)
TASK(/CPMB/CONVERT,KEYDATE,%KEYDATE%)
TASK(/CPMB/CLEAR_DATA,INPUTNO,%TEMPNO1%)
TASK(/CPMB/CLEAR_DATA,CHECKLCK,%CHECKLCK%)
TASK(/CPMB/CLEAR_DATA,KEYDATE,%KEYDATE%)
TASK(/CPMB/APPEND_LOAD,INPUTNO,%TEMPNO1%)
TASK(/CPMB/APPEND_LOAD,ACT_FILE_NO,%ACTNO%)
TASK(/CPMB/APPEND_LOAD,RUNLOGIC,%RUNLOGIC%)
TASK(/CPMB/APPEND_LOAD,CHECKLCK,%CHECKLCK%)
TASK(/CPMB/APPEND_LOAD,CLEARDATA,%CLEARDATA%)
TASK(/CPMB/APPEND_LOAD,KEYDATE,%KEYDATE%)

Selection is fixed in the following lines:

INFO(%CLEARDATA%,0)
INFO(%RUNLOGIC%,0)
INFO(%CHECKLCK%,0)
...
TASK(/CPMB/CONVERT,TRANSFORMATIONFILEPATH,\ROOT\WEBFOLDERS\%APPSET%\%APP%\DATAMANAGER\TRANSFORMATIONFILES\TRANSF_FILE_NAME.xls)

[former_member186338 · Accepted solution]

P.S. Instead of "0" you can select "1" based on requirements!

[former_member186338 · Accepted solution]

P.P.S. Corrected transformation file path - variables used for environment and model

[former_member493004]

thank you so much

Ambika

[former_member493004]

Thank you so much Vadim.

just confirming one thing, if we need to run default logic then it has to be 1

INFO(%RUNLOGIC%,1)

Regards,

Ambika

[former_member186338]

Yes, correct!

Based on:

PROMPT(RADIOBUTTON,%RUNLOGIC%,"Select whether to run default logic for stored values after importing",1,{"Yes","No"},{"1","0"})

Please accept the correct answer!