Customize Data Manager package to Load Transaction data from BW system

[Former Member]

Hi All

I want to customize a DMP to load the Transaction Data from BI cube with user inputs. Current Packages has only "TIME" as input which is running fine. Now, users would like to input "ENTITY" as well along with Time. I have added "ENTITY" as a selection parameter so that user can input specific entity instead of loading all Entities but it is bringing "ZERO"records. Please see image 1 attached.

Below are additions to existing code:

PROMPT(SELECT,%SELECTION%,,"Select Location:","%ENTITY_DIM%",,) 

<Attribute><ID>0COMP_CODE</ID><Operator>1</Operator><LowValue>%ENTITY_DIM%</LowValue><HighValue />

Please note: when I hardcode the entity value, it is working fine. for e.g.

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


please see entire code from DM package below

PROMPT(TEXT,%TIMEPERIOD%,"Please specify calendar month using the following format YYYYMM e.g. 201501",,) 
PROMPT(SELECT,%SELECTION%,,"Select Location:","%ENTITY_DIM%",,) 

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,\ROOT\WEBFOLDERS\PWFP\FREIGHT\DATAMANAGER\TRANSFORMATIONFILES\TRANSACTIONAL LOAD\TF_COSTS_LOAD_FROM_XXXXXXX.xls) 

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

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

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

TASK(/CPMB/INFOPROVIDER_CONVERT,FILE,XXXXXXX) 

TASK(/CPMB/INFOPROVIDER_CONVERT,INFOPROV_SELECTION,<?xml version="1.0" encoding="utf-16"?><Selections xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"><Selection Type="Selection"><Attribute><ID>0COMP_CODE</ID><Operator>1</Operator><LowValue>%ENTITY_DIM%</LowValue><HighValue /></Attribute><Attribute><ID>0CALMONTH</ID><Operator>1</Operator><LowValue>%TIMEPERIOD%</LowValue><HighValue /></Attribute><Attribute><ID>0FISCVARNT</ID><Operator>1</Operator><LowValue>K4</LowValue><HighValue /></Attribute></Selection><Selection Type="FieldList"><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>0CHRT_ACCTS</FieldID><FieldID>0COMP_CODE</FieldID><FieldID>0COMP_CODE__ZHYENTITY</FieldID><FieldID>0COMP_CODE__ZHYREGION</FieldID><FieldID>0COSTELMNT</FieldID><FieldID>0COUNTRY</FieldID><FieldID>0CO_AREA</FieldID><FieldID>0CURRENCY</FieldID><FieldID>0CURTYPE</FieldID><FieldID>0CUST_GRP2</FieldID><FieldID>0DISTR_CHAN</FieldID><FieldID>0DIVISION</FieldID><FieldID>0DOC_NUMBER</FieldID><FieldID>0DOC_TYPE</FieldID><FieldID>0FISCPER</FieldID><FieldID>0FISCPER3</FieldID><FieldID>0FISCVARNT</FieldID><FieldID>0FISCYEAR</FieldID><FieldID>0GL_ACCOUNT</FieldID><FieldID>0G_UABSMG</FieldID><FieldID>0ITEM_CATEG</FieldID><FieldID>0MATERIAL</FieldID><FieldID>0MATERIAL__0EXTMATLGRP</FieldID><FieldID>0MATERIAL__0G_CWWPH1</FieldID><FieldID>0MATERIAL__0G_CWWPH2</FieldID><FieldID>0MATERIAL__0G_CWWPH3</FieldID><FieldID>0MATERIAL__0G_CWWPH4</FieldID><FieldID>0MATERIAL__0G_CWWPH5</FieldID><FieldID>0MATERIAL__0G_CWWPH6</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__ZINTRDAT2</FieldID><FieldID>0MATERIAL__ZMATCATEG</FieldID><FieldID>0MATERIAL__ZMATSBCAT</FieldID><FieldID>0MATERIAL__ZMFGPRCSS</FieldID><FieldID>0MATERIAL__ZNOLABELC</FieldID><FieldID>0MATL_GROUP</FieldID><FieldID>0MATL_GRP_4</FieldID><FieldID>0MAT_PLANT</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_4</FieldID><FieldID>0SALES_OFF</FieldID><FieldID>0PROFIT_CTR</FieldID></Selection></Selections>) 

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,0) 

TASK(/CPMB/LOAD_IP,CHECKLCK,1) 

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

Any ideas what is causing the issue pls.? Please let me know if you need any further information.

BR
Venkat

[former_member186338]

Please use code formatting only for code, not for entire question! Hard to read!

[former_member186338 · Accepted solution]

First - are you sure that you have the same I'd for entity in BW and bpc?

Also, user will be able to select only single entity and you can't use prompt selectinput, only text or combobox.

[Former Member]

Thanks Vadim. To answer your questions;

First - are you sure that you have the same I'd for entity in BW and bpc? - No, they are different

Also user will able to select only single entity and you can't use prompt selectinput, only text or combobox. - right, it is working only for one Entity when I use Text and this has solved my requirement.

Thanks again for your support.

BR

Venkat

[former_member186338]

"First - are you sure that you have the same I'd for entity in BW and bpc? - No, they are different" - then forget about SELECTINPUT also for this reason 🙂

Instead of TEXT you can use COMBOBOX with a fixed list of codes (if the list is not very long)