Set Default Info provider, Transformation file for Data Manager Package in EPM10

[Former Member]

Hi All,

I would require your help to make few changes to the Data Manager "Load Transaction Data from InfoProvider UI (having process chain, /CPMB/LOAD_INFOPROV_UI). The requirements are;

1. Set the default info provider in Display mode in the First prompt screen.

2. Set selection for the Info provider should be hard coded except for Fiscal year/Period where in the user should be able to change only the Fiscal Year/Period every month.

3. Set the default Transformation file in Display mode so that user should not be able to change.

I have tried changing for Info provider and Transformation file by seeing some old posts but when running the DM package, I could not see the Info provider screen and Transformation file screen. I would like to see both of them but in Display mode.

Please see default Advance script code below.

PROMPT(INFOPROVIDERSELECTION,%InforProvide%,%SELECTION%,"Please select the InfoProvider and set selection (InfoProvider list is restricted by both BW and BPC authority)",,)

PROMPT(TRANSFORMATION,%TRANSFORMATION%,"Transformation file:",,,Import.xls)

PROMPT(RADIOBUTTON,%TARGETMODE%,"Handling of records in target",0,{"Append","Overwrite records with match key","Replace data in same data region of Entity, Category, Time and Audit ID"},{"0","1","2"})

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/INFOPROVIDER_CONVERT,OUTPUTNO,%TEMPNO1%)

TASK(/CPMB/INFOPROVIDER_CONVERT,ACT_FILE_NO,%ACTNO%)

TASK(/CPMB/INFOPROVIDER_CONVERT,TRANSFORMATIONFILEPATH,%TRANSFORMATION%)

TASK(/CPMB/INFOPROVIDER_CONVERT,SUSER,%USER%)

TASK(/CPMB/INFOPROVIDER_CONVERT,SAPPSET,%APPSET%)

TASK(/CPMB/INFOPROVIDER_CONVERT,SAPP,%APP%)

TASK(/CPMB/INFOPROVIDER_CONVERT,FILE,%InforProvide%)

TASK(/CPMB/INFOPROVIDER_CONVERT,INFOPROV_SELECTION,%SELECTION%)

TASK(/CPMB/INFOPROVIDER_CONVERT,KEYDATE,%KEYDATE%)

TASK(/CPMB/LOAD_IP,PREPROCESSMODE,0)

TASK(/CPMB/LOAD_IP,TARGETMODE,%TARGETMODE%)

TASK(/CPMB/LOAD_IP,INPUTNO,%TEMPNO1%)

TASK(/CPMB/LOAD_IP,ACT_FILE_NO,%ACTNO%)

TASK(/CPMB/LOAD_IP,RUNLOGIC,%RUNLOGIC%)

TASK(/CPMB/LOAD_IP,CHECKLCK,%CHECKLCK%)

TASK(/CPMB/LOAD_IP,KEYDATE,%KEYDATE%)

Thanks in advance,

Best Regards,

Venkat

[former_member186338 · Accepted solution]

Sorry,

But why not to search forum for discussions like

The only issue is to select Fiscal Year and Month - but you can use PROMPT(COMBOBOX... with the list of values.

Vadim

P.S. Read also from here:

[Former Member · Accepted solution]

Hi Vadim,

Thanks for the prompt response. I had gone through the above links and tried to modify the Advance Script but have few questions pls.

1. Info provider can not be Hardcoded right? Please confirm? I have read in your old post.

----------------------------------------------------------------------------------------------------------------------------------------------------

Hi Arnold,

PROMPT(INFORPORIVDERSELECTION,%InforProvide%,%SELECTION%,...

will always prompt for infoprovider and for selection. You can fix infoprovider, but it will be anyway prompted

Vadim

-------------------------------------------------------------------------------------------------------------------------------------------------

2. If I am using Combo box or prompts for the Fiscal Year/Period, then how can I Greyout the "Set selection" so that users cannot make any selection via "Set Selection". The one Highlighted below, I would like to grey it out.

3. I have hardcoded the Transformation file, but can I get an option to see the Transformastion file in Display mode? Currently, it is skipping that step and directly moving to the next step.

4. Please see my customized code below. Can you please let me know if you see any mistakes? Only Fiscal Year/Period should be user Input and rest has to be Hardcoded.

PROMPT(INFOPROVIDERSELECTION,%InforProvide%,%SELECTION%,"Please select the InfoProvider and set selection (InfoProvider list is restricted by both BW and BPC authority)",,)

PROMPT(TEXT,[Fiscal year/period],"Fiscal year/period")

'PROMPT(TRANSFORMATION,%TRANSFORMATION%,"Transformation file:",,,Import.xls)

PROMPT(RADIOBUTTON,%TARGETMODE%,"Handling of records in target",1,{"Overwrite records with match key"},{"1"})

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

PROMPT(RADIOBUTTON,%CHECKLCK%,"Select whether to check work status settings when importing data.",0,{"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%)

TASK(/CPMB/INFOPROVIDER_CONVERT,OUTPUTNO,%TEMPNO1%)

TASK(/CPMB/INFOPROVIDER_CONVERT,ACT_FILE_NO,%ACTNO%)

INFO(%SELECTION%,<Selections><Selection Type="Selection"><Attribute>

<Attribute><ID>0VERSION</ID><Operator>2</Operator><LowValue>ACTUAL</LowValue><HighValue /></Attribute>

<Attribute><ID>0VTYPE</ID><Operator>2</Operator><LowValue>10</LowValue><HighValue /></Attribute>

<Attribute><ID>0CURTYPE</ID><Operator>2</Operator><LowValue>10</LowValue><HighValue /></Attribute>

<Attribute><ID>0CO_AREA</ID><Operator>2</Operator><LowValue>PI01</LowValue><HighValue /></Attribute>

<Attribute><ID>0COMPCODE</ID><Operator>2</Operator><LowValue>IN02</LowValue><HighValue /></Attribute>

<Attribute><ID>0ITEM_CATEG</ID><Operator>2</Operator><LowValue>ZSFG</LowValue><HighValue /></Attribute>

</Selection></Selections>'TASK(/CPMB/INFOPROVIDER_CONVERT,TRANSFORMATIONFILEPATH,%TRANSFORMATION%)

TASK(/CPMB/INFOPROVIDER_CONVERT,TRANSFORMATIONFILEPATH,\ROOT\WEBFOLDERS\COGS ADMIN\DATAMANAGER\TEAMTRANSFORMATIONFILES\MONTH END DATA LOADS\ZPAC0001 DATA LOAD - COMPONENT.XLS)

TASK(/CPMB/INFOPROVIDER_CONVERT,SUSER,%USER%)

TASK(/CPMB/INFOPROVIDER_CONVERT,SAPPSET,%APPSET%)

TASK(/CPMB/INFOPROVIDER_CONVERT,SAPP,%APP%)

TASK(/CPMB/INFOPROVIDER_CONVERT,FILE,%InforProvide%)

TASK(/CPMB/INFOPROVIDER_CONVERT,INFOPROV_SELECTION,%SELECTION%)

TASK(/CPMB/INFOPROVIDER_CONVERT,KEYDATE,%KEYDATE%)

TASK(/CPMB/LOAD_IP,PREPROCESSMODE,0)TASK(/CPMB/LOAD_IP,TARGETMODE,1)

TASK(/CPMB/LOAD_IP,INPUTNO,%TEMPNO1%)TASK(/CPMB/LOAD_IP,ACT_FILE_NO,%ACTNO%)

TASK(/CPMB/LOAD_IP,RUNLOGIC,1)

TASK(/CPMB/LOAD_IP,CHECKLCK,1)

TASK(/CPMB/LOAD_IP,KEYDATE,%KEYDATE%)

Thanks in advance,

Best Regards,

Venkata

[former_member186338 · Accepted solution]

"1. Info provider can not be Hardcoded right?" - incorrect, it can be hardcoded but only with SELECTION!

2. PROMPT(INFORPORIVDERSELECTION,%InforProvide%,%SELECTION%,... - has to be removed completely!

3. "I have hardcoded the Transformation file, but can I get an option to see the Transformastion file in Display mode?" - no, you can't!

4. I don't see a year / period selection in xml SELECTION! Look here for some sample:

Vadim

P.S. And what do you mean by syntax like:

PROMPT(TEXT,[Fiscal year/period],"Fiscal year/period")

Read: TEXT Prompt() Command - SAP BusinessObjects Planning and Consolidation - SAP Library

[Former Member · Accepted solution]

Hi Vadim,

Thanks again but I am still not getting 2 things. Can you please help?

1. How and in which row can I hardcode the Info provider?

2. For Calmonth combo box, the user should be able to select values from the Dropdown box. For e.g. user should be able to select 201501,201502,201503 etc.

Please see my code below;

'PROMPT(TRANSFORMATION,%TRANSFORMATION%,"Transformation file:",,,Import.xls)

PROMPT(RADIOBUTTON,%TARGETMODE%,"Handling of records in target",1,{"Overwrite records with match key"},{"1"})

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

PROMPT(RADIOBUTTON,%CHECKLCK%,"Select whether to check work status settings when importing data.",0,{"Yes, check for work status settings before importing","No, do not check work status settings"},{"1","0"})

PROMPT(KEYDATE,%KEYDATE%,"Key date",0)

PROMPT(COMBOBOX,%TIME%,Please enter the Time,0,201401,201402,201403,201404,201405)

INFO(%TEMPNO1%,%INCREASENO%)

INFO(%ACTNO%,%INCREASENO%)

TASK(/CPMB/INFOPROVIDER_CONVERT,OUTPUTNO,%TEMPNO1%)

TASK(/CPMB/INFOPROVIDER_CONVERT,ACT_FILE_NO,%ACTNO%)

INFO(%SELECTION%,<Selection Type="Selection"><Attribute><ID>0COMP_CODE</ID><Operator>1</Operator><LowValue>IN02</LowValue><HighValue /></Attribute><Attribute><ID>0CURTYPE</ID><Operator>1</Operator><LowValue>10</LowValue><HighValue /></Attribute><Attribute><ID>0VTYPE</ID><Operator>1</Operator><LowValue>10</LowValue><HighValue /></Attribute><Attribute><ID>0MATERIAL__0MATL_TYPE</ID><Operator>1</Operator><LowValue>ZSFG</LowValue><HighValue /></Attribute><Attribute><ID>0ITEM_CATEG</ID><Operator>1</Operator><LowValue>TAN</LowValue><HighValue /></Attribute><Attribute><ID>0CALMONTH</ID><Operator>1</Operator><LowValue>%TIME_X%</LowValue><HighValue /></Attribute><Attribute><ID>0ITEM_CATEG</ID><Operator>1</Operator><LowValue>ZKEW</LowValue><HighValue /></Attribute><Attribute><ID>0ITEM_CATEG</ID><Operator>1</Operator><LowValue>ZKL2</LowValue><HighValue /></Attribute><Attribute><ID>0ITEM_CATEG</ID><Operator>1</Operator><LowValue>ZRE9</LowValue><HighValue /></Attribute><Attribute><ID>0ITEM_CATEG</ID><Operator>1</Operator><LowValue>ZKIF</LowValue><HighValue /></Attribute></Selection><Selection Type="FieldList"><FieldID>0ACCNT_ASGN</FieldID><FieldID>0BILLTOPRTY</FieldID><FieldID>0BILLTOPRTY__0CUST_CLASS</FieldID><FieldID>0BILLTOPRTY__0IND_CODE_1</FieldID><FieldID>0BILL_TYPE</FieldID><FieldID>0BUS_AREA</FieldID><FieldID>0CALDAY</FieldID><FieldID>0CALMONTH</FieldID><FieldID>0CALMONTH2</FieldID><FieldID>0CALQUART1</FieldID><FieldID>0CALQUARTER</FieldID><FieldID>0CALWEEK</FieldID><FieldID>0CALYEAR</FieldID><FieldID>0CHNGID</FieldID><FieldID>0COMP_CODE</FieldID><FieldID>0COMP_CODE__0COUNTRY</FieldID><FieldID>0COMP_CODE__ZHYENTITY</FieldID><FieldID>0COMP_CODE__ZHYREGION</FieldID><FieldID>0COSTELMNT</FieldID><FieldID>0COUNTRY</FieldID><FieldID>0CO_AREA</FieldID><FieldID>0CRM_EXTYPE</FieldID><FieldID>0CRM_MKTELM</FieldID><FieldID>0CURRENCY</FieldID><FieldID>0CURTYPE</FieldID><FieldID>0CUST_CLASS</FieldID><FieldID>0CUST_GROUP</FieldID><FieldID>0CUST_GRP1</FieldID><FieldID>0CUST_GRP2</FieldID><FieldID>0CUST_GRP3</FieldID><FieldID>0CUST_GRP4</FieldID><FieldID>0CUST_GRP5</FieldID><FieldID>0CUST_HIE01</FieldID><FieldID>0CUST_HIE02</FieldID><FieldID>0CUST_HIE03</FieldID><FieldID>0DISTR_CHAN</FieldID><FieldID>0DIVISION</FieldID><FieldID>0DOC_TYPE</FieldID><FieldID>0FISCPER</FieldID><FieldID>0FISCPER3</FieldID><FieldID>0FISCVARNT</FieldID><FieldID>0FISCYEAR</FieldID><FieldID>0G_CWWPH1</FieldID><FieldID>0G_CWWPH2</FieldID><FieldID>0G_CWWPH3</FieldID><FieldID>0G_CWWPH4</FieldID><FieldID>0G_CWWPH5</FieldID><FieldID>0G_CWWPH6</FieldID><FieldID>0G_CWWPH7</FieldID><FieldID>0G_UABSMG</FieldID><FieldID>0G_UVV8OZ</FieldID><FieldID>0G_UVV902</FieldID><FieldID>0G_UVV903</FieldID><FieldID>0G_UVV904</FieldID><FieldID>0G_UVV905</FieldID><FieldID>0INDUSTRY</FieldID><FieldID>0IND_CODE_1</FieldID><FieldID>0ITEM_CATEG</FieldID><FieldID>0MATERIAL</FieldID><FieldID>0MATERIAL__0CREATEDON</FieldID><FieldID>0MATERIAL__0G_CWWPH7</FieldID>

<FieldID>0MATERIAL__0MATL_CAT</FieldID><FieldID>0MATERIAL__0MATL_GROUP</FieldID><FieldID>0MATERIAL__0MATL_TYPE</FieldID><FieldID>0MATERIAL__0PROD_HIER</FieldID><FieldID>0MATERIAL__ZANZCONOC</FieldID><FieldID>0MATERIAL__ZANZSCALE</FieldID><FieldID>0MATERIAL__ZBCPCLASS</FieldID><FieldID>0MATERIAL__ZBISMT</FieldID><FieldID>0MATERIAL__ZCS_PROD</FieldID><FieldID>0MATERIAL__ZCS_SIZE</FieldID><FieldID>0MATERIAL__ZC_REASON</FieldID><FieldID>0MATERIAL__ZDP_PFLAG</FieldID><FieldID>0MATERIAL__ZDP_PMATL</FieldID><FieldID>0MATERIAL__ZINTRDAT2</FieldID><FieldID>0MATERIAL__ZMATCATEG</FieldID><FieldID>0MATERIAL__ZMATSBCAT</FieldID><FieldID>0MATERIAL__ZMFGPRCSS</FieldID><FieldID>0MATERIAL__ZMULPACK</FieldID><FieldID>0MATERIAL__ZNOLABELC</FieldID><FieldID>0MATERIAL__ZSHELF</FieldID><FieldID>0MATL_GROUP</FieldID><FieldID>0MATL_GRP_1</FieldID><FieldID>0MATL_GRP_4</FieldID><FieldID>0MAT_PLANT</FieldID><FieldID>0MAT_PLANT__0ABCKEY</FieldID><FieldID>0MAT_PLANT__0MRP_CONTRL</FieldID><FieldID>0MAT_PLANT__0VALIDFROM</FieldID><FieldID>0MAT_PLANT__ZPWFWGTFI</FieldID><FieldID>0MAT_SALES</FieldID><FieldID>0MAT_SALES__0MATL_GRP_1</FieldID><FieldID>0MAT_SALES__0MATL_GRP_4</FieldID><FieldID>0ORD_REASON</FieldID><FieldID>ZVAL_TYPE</FieldID></Selection></Selections>

'TASK(/CPMB/INFOPROVIDER_CONVERT,TRANSFORMATIONFILEPATH,%TRANSFORMATION%)

TASK(/CPMB/INFOPROVIDER_CONVERT,TRANSFORMATIONFILEPATH,\ROOT\WEBFOLDERS\COGS ADMIN\DATAMANAGER\TEAMTRANSFORMATIONFILES\MONTH END DATA LOADS\ZPAC0001 DATA LOAD - COMPONENT.XLS)

TASK(/CPMB/INFOPROVIDER_CONVERT,SUSER,%USER%)

TASK(/CPMB/INFOPROVIDER_CONVERT,SAPPSET,%APPSET%)

TASK(/CPMB/INFOPROVIDER_CONVERT,SAPP,%APP%)

TASK(/CPMB/INFOPROVIDER_CONVERT,FILE,%InforProvide%)

TASK(/CPMB/INFOPROVIDER_CONVERT,INFOPROV_SELECTION,%SELECTION%)

TASK(/CPMB/INFOPROVIDER_CONVERT,KEYDATE,%KEYDATE%)

TASK(/CPMB/LOAD_IP,PREPROCESSMODE,0)TASK(/CPMB/LOAD_IP,TARGETMODE,1)

TASK(/CPMB/LOAD_IP,INPUTNO,%TEMPNO1%)TASK(/CPMB/LOAD_IP,ACT_FILE_NO,%ACTNO%)

TASK(/CPMB/LOAD_IP,RUNLOGIC,1)

TASK(/CPMB/LOAD_IP,CHECKLCK,1)

TASK(/CPMB/LOAD_IP,KEYDATE,%KEYDATE%)

Thanks in advance,

Best Regards,

Venkata

[former_member186338 · Accepted solution]

1. TASK(/CPMB/INFOPROVIDER_CONVERT,FILE,%InforProvide%) - hardcode here instead of %InforProvide%

2. PROMPT(COMBOBOX,%TIME_X%,"Please enter the Time",0,201401,201402,201403,201404,201405)

INFO(%SELECTION%,<...></Attribute><Attribute><ID>0CALMONTH</ID><Operator>1</Operator><LowValue>%TIME_X%</LowValue><HighValue />...

Use %TIME_X% variable to pass value selected by user in COMBOBOX to the SELECTION string

Vadim

[Former Member · Accepted solution]

Hi Vadim,

Thanks again. few questions please;

1. The Hard coded Info provider cannot be seen in "Display mode" as well right when we run the DM package? Please confirm.

2. For e.g. I have 10 fields in the BI info provider and I need to give selections for only 5 fields while executing the DM Package. Should i still include all the 10 fields in the Advanced script of the DM package or only the 5 which needs selections?

3. For CALMONTH, I have made changes as requested but when I execute the DM package, I can only see 2 values. Please see the screen shot below; can you please help on this?

Please see my whole code below;

'PROMPT(TRANSFORMATION,%TRANSFORMATION%,"Transformation file:",,,Import.xls)

PROMPT(RADIOBUTTON,%TARGETMODE%,"Handling of records in target",1,{"Overwrite records with match key"},{"1"})

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

PROMPT(RADIOBUTTON,%CHECKLCK%,"Select whether to check work status settings when importing data.",0,{"Yes, check for work status settings before importing","No, do not check work status settings"},{"1","0"})

PROMPT(KEYDATE,%KEYDATE%,"Key date",0)

PROMPT(COMBOBOX,%TIME_X%,Please enter the Time,0,201401,201402,201403,201404,201405)

INFO(%TEMPNO1%,%INCREASENO%)

INFO(%ACTNO%,%INCREASENO%)

TASK(/CPMB/INFOPROVIDER_CONVERT,OUTPUTNO,%TEMPNO1%)

TASK(/CPMB/INFOPROVIDER_CONVERT,ACT_FILE_NO,%ACTNO%)

INFO(%SELECTION%,<Selection Type="Selection">

<Attribute><ID>0COMP_CODE</ID><Operator>1</Operator><LowValue>IN02</LowValue><HighValue /></Attribute>

<Attribute><ID>0CURTYPE</ID><Operator>1</Operator><LowValue>10</LowValue><HighValue /></Attribute>

<Attribute><ID>0VTYPE</ID><Operator>1</Operator><LowValue>10</LowValue><HighValue /></Attribute>

<Attribute><ID>0MATERIAL__0MATL_TYPE</ID><Operator>1</Operator><LowValue>ZSFG</LowValue><HighValue /></Attribute>

<Attribute><ID>0ITEM_CATEG</ID><Operator>1</Operator><LowValue>TAN</LowValue><HighValue /></Attribute>

<Attribute><ID>0CALMONTH</ID><Operator>1</Operator><LowValue>%TIME_X%</LowValue><HighValue /></Attribute>

<Attribute><ID>0ITEM_CATEG</ID><Operator>1</Operator><LowValue>ZKEW</LowValue><HighValue /></Attribute>

<Attribute><ID>0ITEM_CATEG</ID><Operator>1</Operator><LowValue>ZKL2</LowValue><HighValue /></Attribute>

<Attribute><ID>0ITEM_CATEG</ID><Operator>1</Operator><LowValue>ZRE9</LowValue><HighValue /></Attribute>

<Attribute><ID>0ITEM_CATEG</ID><Operator>1</Operator><LowValue>ZKIF</LowValue>

<HighValue /></Attribute></Selection><Selection Type="FieldList">

<FieldID>0ACCNT_ASGN</FieldID><FieldID>0BILLTOPRTY</FieldID><FieldID>0BILLTOPRTY__0CUST_CLASS</FieldID><FieldID>0BILLTOPRTY__0IND_CODE_1</FieldID><FieldID>0BILL_TYPE</FieldID><FieldID>ZUNIT_EA</FieldID><FieldID>ZUPMAT</FieldID><FieldID>ZUPMAT__0MATL_TYPE</FieldID><FieldID>ZUVOL_LTR</FieldID><FieldID>ZVAL_TYPE</FieldID></Selection></Selections>

'TASK(/CPMB/INFOPROVIDER_CONVERT,TRANSFORMATIONFILEPATH,%TRANSFORMATION%)

TASK(/CPMB/INFOPROVIDER_CONVERT,TRANSFORMATIONFILEPATH,\ROOT\WEBFOLDERS\COGS ADMIN\DATAMANAGER\TEAMTRANSFORMATIONFILES\MONTH END DATA LOADS\ZPAC0001 DATA LOAD - COMPONENT.XLS)

TASK(/CPMB/INFOPROVIDER_CONVERT,SUSER,%USER%)

TASK(/CPMB/INFOPROVIDER_CONVERT,SAPPSET,%APPSET%)

TASK(/CPMB/INFOPROVIDER_CONVERT,SAPP,%APP%)

TASK(/CPMB/INFOPROVIDER_CONVERT,FILE,ZPAC0001)

TASK(/CPMB/INFOPROVIDER_CONVERT,INFOPROV_SELECTION,%SELECTION%)

TASK(/CPMB/INFOPROVIDER_CONVERT,KEYDATE,%KEYDATE%)

TASK(/CPMB/LOAD_IP,PREPROCESSMODE,0)TASK(/CPMB/LOAD_IP,TARGETMODE,1)

TASK(/CPMB/LOAD_IP,INPUTNO,%TEMPNO1%)TASK(/CPMB/LOAD_IP,ACT_FILE_NO,%ACTNO%)

TASK(/CPMB/LOAD_IP,RUNLOGIC,1)

TASK(/CPMB/LOAD_IP,CHECKLCK,1)

TASK(/CPMB/LOAD_IP,KEYDATE,%KEYDATE%)

Thanks in advance,

Regards,

Venkata

[former_member186338 · Accepted solution]

1. It can't be seen!

2. If you don't need to select - try not including... test at least something yourself!

3. For COMBOBOX - small syntax mistake, have to be:

PROMPT(COMBOBOX,%TIME_X%,"Please enter the Time",0,201401,{201401,201402,201403,201404,201405})

Read:

P.S. You can show user some message using PROMPT(MESSAGE,"Message Text")

[Former Member · Accepted solution]

Thanks again Vadim,

1. I executed the DM package but its failing with the below error message. The path to the Transformation file is correct. Please see the error message below.

2. The CALMONTH works fine when the values are Hardcoded but can you please let me know if the values can be dynamically be called up. For e.g. Please see below screen shot. I hard coded the CALMONTH values.

Advanced DM Package code for your reference.

'PROMPT(TRANSFORMATION,%TRANSFORMATION%,"Transformation file:",,,Import.xls)

PROMPT(RADIOBUTTON,%TARGETMODE%,"Handling of records in target",1,{"Overwrite records with match key"},{"1"})

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

PROMPT(RADIOBUTTON,%CHECKLCK%,"Select whether to check work status settings when importing data.",0,{"Yes, check for work status settings before importing","No, do not check work status settings"},{"1","0"})

PROMPT(KEYDATE,%KEYDATE%,"Key date",0)

PROMPT(COMBOBOX,%TIME_X%,"Please enter the Time",1,,{201401,201402,201403,201404,201405})

INFO(%TEMPNO1%,%INCREASENO%)

INFO(%ACTNO%,%INCREASENO%)

TASK(/CPMB/INFOPROVIDER_CONVERT,OUTPUTNO,%TEMPNO1%)

TASK(/CPMB/INFOPROVIDER_CONVERT,ACT_FILE_NO,%ACTNO%)

INFO(%SELECTION%,<Selection Type="Selection"><Attribute><ID>0COMP_CODE</ID><Operator>1</Operator><LowValue>IN02</LowValue><HighValue /></Attribute><Attribute><ID>0CURTYPE</ID><Operator>1</Operator><LowValue>10</LowValue><HighValue /></Attribute><Attribute><ID>0VTYPE</ID><Operator>1</Operator><LowValue>10</LowValue><HighValue /></Attribute><Attribute><ID>0MATERIAL__0MATL_TYPE</ID><Operator>1</Operator><LowValue>ZSFG</LowValue><HighValue /></Attribute><Attribute><ID>0ITEM_CATEG</ID><Operator>1</Operator><LowValue>TAN</LowValue><HighValue /></Attribute><Attribute><ID>0CALMONTH</ID><Operator>1</Operator><LowValue>%TIME_X%</LowValue><HighValue /></Attribute><Attribute><ID>0ITEM_CATEG</ID><Operator>1</Operator><LowValue>ZKEW</LowValue><HighValue /></Attribute><Attribute><ID>0ITEM_CATEG</ID><Operator>1</Operator><LowValue>ZKL2</LowValue><HighValue /></Attribute><Attribute><ID>0ITEM_CATEG</ID><Operator>1</Operator><LowValue>ZRE9</LowValue><HighValue /></Attribute><Attribute><ID>0ITEM_CATEG</ID><Operator>1</Operator><LowValue>ZKIF</LowValue><HighValue /></Attribute></Selection><Selection Type="FieldList"><FieldID>0ACCNT_ASGN</FieldID><FieldID>0BILLTOPRTY</FieldID><FieldID>0BILLTOPRTY__0CUST_CLASS</FieldID><FieldID>0BILLTOPRTY__0IND_CODE_1</FieldID><FieldID>0BILL_TYPE</FieldID><FieldID>0BUS_AREA</FieldID><FieldID>0CALDAY</FieldID><FieldID>0CALMONTH</FieldID><FieldID>0CALMONTH2</FieldID><FieldID>0CALQUART1</FieldID><FieldID>0CALQUARTER</FieldID><FieldID>0CALWEEK</FieldID><FieldID>0CALYEAR</FieldID><FieldID>0CHNGID</FieldID><FieldID>0COMP_CODE</FieldID><FieldID>0COMP_CODE__0COUNTRY</FieldID><FieldID>0COMP_CODE__ZHYENTITY</FieldID><FieldID>0COMP_CODE__ZHYREGION</FieldID><FieldID>0COSTELMNT</FieldID><FieldID>0COUNTRY</FieldID><FieldID>0CO_AREA</FieldID><FieldID>0CRM_EXTYPE</FieldID><FieldID>0CRM_MKTELM</FieldID><FieldID>0CURRENCY</FieldID><FieldID>0CURTYPE</FieldID>

'TASK(/CPMB/INFOPROVIDER_CONVERT,TRANSFORMATIONFILEPATH,%TRANSFORMATION%)

TASK(/CPMB/INFOPROVIDER_CONVERT,TRANSFORMATIONFILEPATH,\ROOT\WEBFOLDERS\COGS ADMIN\DATAMANAGER\TEAMTRANSFORMATIONFILES\MONTH END DATA LOADS\ZPAC0001 DATA LOAD - COMPONENT.XLS)

TASK(/CPMB/INFOPROVIDER_CONVERT,SUSER,%USER%)

TASK(/CPMB/INFOPROVIDER_CONVERT,SAPPSET,%APPSET%)

TASK(/CPMB/INFOPROVIDER_CONVERT,SAPP,%APP%)

TASK(/CPMB/INFOPROVIDER_CONVERT,FILE,ZPAC0001)

TASK(/CPMB/INFOPROVIDER_CONVERT,INFOPROV_SELECTION,%SELECTION%)

TASK(/CPMB/INFOPROVIDER_CONVERT,KEYDATE,%KEYDATE%)

TASK(/CPMB/LOAD_IP,PREPROCESSMODE,0)TASK(/CPMB/LOAD_IP,TARGETMODE,1)

TASK(/CPMB/LOAD_IP,INPUTNO,%TEMPNO1%)TASK(/CPMB/LOAD_IP,ACT_FILE_NO,%ACTNO%)

TASK(/CPMB/LOAD_IP,RUNLOGIC,1)

TASK(/CPMB/LOAD_IP,CHECKLCK,1)

TASK(/CPMB/LOAD_IP,KEYDATE,%KEYDATE%)

Thanks in advance,

Best Regards,

Venkat

[former_member186338 · Accepted solution]

1. "I executed the DM package but its failing with the below error message. The path to the Transformation file is correct." - incorrect!

you have:

TASK(/CPMB/INFOPROVIDER_CONVERT,TRANSFORMATIONFILEPATH,\ROOT\WEBFOLDERS\COGS ADMIN\DATAMANAGER\TEAMTRANSFORMATIONFILES\MONTH END DATA LOADS\ZPAC0001 DATA LOAD - COMPONENT.XLS)

But the path is like:

\ROOT\WEBFOLDERS\ENVIRONMENT\MODEL\DATAMANAGER\...

2. "The CALMONTH works fine when the values are Hardcoded but can you please let me know if the values can be dynamically be called up. For e.g. Please see below screen shot. I hard coded the CALMONTH values." - Only hardcoded list of values, no other way!

Vadim

[former_member186338 · Accepted solution]

Correct path to transformation file will be:

\ROOT\WEBFOLDERS\ENVIRONMENT\MODEL\TEAM FILES\ADMIN\DATAMANAGER\TRANSFORMATIONFILES\MONTH END DATA LOADS\ZPAC0001 DATA LOAD - COMPONENT.XLS

You have to copy from here:

Vadim

[Former Member · Accepted solution]

Hi Vadim,

Thanks again for your support. I changed it accordingly but I have a new error. Please see the error screen shot below.

The issue cannot be in the start routine because,we use the same DM Package and the Transformation file before I started customizing in the advanced script. That is working fine. I even executed the old one now and it ran successfully.

Please see the code below for your reference.

'PROMPT(TRANSFORMATION,%TRANSFORMATION%,"Transformation file:",,,Import.xls)

PROMPT(RADIOBUTTON,%TARGETMODE%,"Handling of records in target",1,{"Overwrite records with match key"},{"1"})

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

PROMPT(RADIOBUTTON,%CHECKLCK%,"Select whether to check work status settings when importing data.",0,{"Yes, check for work status settings before importing","No, do not check work status settings"},{"1","0"})

PROMPT(KEYDATE,%KEYDATE%,"Key date",0)

PROMPT(COMBOBOX,%TIME_X%,"Please enter the Time",1,,{201401,201402,201403,201404,201405})

INFO(%TEMPNO1%,%INCREASENO%)

INFO(%ACTNO%,%INCREASENO%)

TASK(/CPMB/INFOPROVIDER_CONVERT,OUTPUTNO,%TEMPNO1%)

TASK(/CPMB/INFOPROVIDER_CONVERT,ACT_FILE_NO,%ACTNO%)

INFO(%SELECTION%,<Selection Type="Selection"><Attribute><ID>0COMP_CODE</ID><Operator>1</Operator><LowValue>IN02</LowValue><HighValue /></Attribute><Attribute><ID>0CURTYPE</ID><Operator>1</Operator><LowValue>10</LowValue><HighValue /></Attribute><Attribute><ID>0VTYPE</ID><Operator>1</Operator><LowValue>10</LowValue><HighValue /></Attribute><Attribute><ID>0MATERIAL__0MATL_TYPE</ID><Operator>1</Operator><LowValue>ZSFG</LowValue><HighValue /></Attribute><Attribute><ID>0ITEM_CATEG</ID><Operator>1</Operator><LowValue>TAN</LowValue><HighValue /></Attribute><Attribute><ID>0CALMONTH</ID><Operator>1</Operator><LowValue>%TIME_X%</LowValue><HighValue /></Attribute><Attribute><ID>0ITEM_CATEG</ID><Operator>1</Operator><LowValue>ZKEW</LowValue><HighValue /></Attribute><Attribute><ID>0ITEM_CATEG</ID><Operator>1</Operator><LowValue>ZKL2</LowValue><HighValue /></Attribute><Attribute><ID>0ITEM_CATEG</ID><Operator>1</Operator><LowValue>ZRE9</LowValue><HighValue /></Attribute><Attribute><ID>0ITEM_CATEG</ID><Operator>1</Operator><LowValue>ZKIF</LowValue><HighValue /></Attribute></Selection><Selection Type="FieldList"><FieldID>0ACCNT_ASGN</FieldID><FieldID>0BILLTOPRTY</FieldID><FieldID>0BILLTOPRTY__0CUST_CLASS</FieldID><FieldID>0BILLTOPRTY__0IND_CODE_1</FieldID><FieldID>0BILL_TYPE</FieldID><FieldID>0BUS_AREA</FieldID><FieldID>0CALDAY</FieldID><FieldID>0CALMONTH</FieldID><FieldID>0CALMONTH2</FieldID><FieldID>0CALQUART1</FieldID><FieldID>0CALQUARTER</FieldID><FieldID>0CALWEEK</FieldID><FieldID>0CALYEAR</FieldID><FieldID>0CHNGID</FieldID><FieldID>0COMP_CODE</FieldID><FieldID>0COMP_CODE__0COUNTRY</FieldID><FieldID>0COMP_CODE__ZHYENTITY</FieldID><FieldID>0COMP_CODE__ZHYREGION</FieldID><FieldID>0COSTELMNT</FieldID><FieldID>0COUNTRY</FieldID><FieldID>0CO_AREA</FieldID>

'TASK(/CPMB/INFOPROVIDER_CONVERT,TRANSFORMATIONFILEPATH,%TRANSFORMATION%)

TASK(/CPMB/INFOPROVIDER_CONVERT,TRANSFORMATIONFILEPATH,\ROOT\WEBFOLDERS\PYRAMID\COGS\TEAM FILES\COGS ADMIN\DATAMANAGER\TRANSFORMATIONFILES\MONTH END DATA LOADS\ZPAC0001 DATA LOAD - COMPONENT.XLS)

TASK(/CPMB/INFOPROVIDER_CONVERT,SUSER,%USER%)

TASK(/CPMB/INFOPROVIDER_CONVERT,SAPPSET,%APPSET%)

TASK(/CPMB/INFOPROVIDER_CONVERT,SAPP,%APP%)

TASK(/CPMB/INFOPROVIDER_CONVERT,FILE,ZPAC0001)

TASK(/CPMB/INFOPROVIDER_CONVERT,INFOPROV_SELECTION,%SELECTION%)

TASK(/CPMB/INFOPROVIDER_CONVERT,KEYDATE,%KEYDATE%)

TASK(/CPMB/LOAD_IP,PREPROCESSMODE,0)TASK(/CPMB/LOAD_IP,TARGETMODE,1)

TASK(/CPMB/LOAD_IP,INPUTNO,%TEMPNO1%)TASK(/CPMB/LOAD_IP,ACT_FILE_NO,%ACTNO%)

TASK(/CPMB/LOAD_IP,RUNLOGIC,1)

TASK(/CPMB/LOAD_IP,CHECKLCK,1)

TASK(/CPMB/LOAD_IP,KEYDATE,%KEYDATE%)

[former_member186338 · Accepted solution]

May be you have made some errors in the fixed SELECTION text. I am unable to check and don't want to check! If you create it properly then - no issues!

Vadim

Ups, I can see number of errors!...

[former_member186338 · Accepted solution]

Execute the old advanced script and during execution - save selection to ESF file (with some 0CALMONTH selected). Ensure that everything work fine with the saved selection. Then download the xxx.esf file from the server (using transaction UJFS). Then use this file to prepare a correct fixed %SELECTION% - something like:

<Selections>

<Selection Type="Selection">

<Attribute><ID>0COMP_CODE...

...

</Selection>

<Selection Type="FieldList">

<FieldID>0ACCNT_ASGN</FieldID>

...

</Selection>

</Selections>

Vadim