Skip to Content
0
Jul 15, 2019 at 08:03 AM

Prompts in DMP to be replaced with fixed values

70 Views

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