on 07-15-2019 9:03 AM
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
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)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
thank you so much
Ambika
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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!
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.