Skip to Content
0
Sep 30, 2019 at 01:11 PM

Can we hardcode a field in BW to BPC upload DM package using Selection file or DM package?

161 Views

Hi Experts,

I am using the DM package - /CPMB/LOAD_INFOPROV_UI for uploading the data from a composite provider.

BW Object - ZIP_PLVER (FORECAST) to BPC Dim - CATEGORY (FORECAST_IP)

1) I use a selection file for the load, and the requirement is to hardcode the category to FORECAST (if not possible, to make the field IP Category as a mandatory selection, so users can select FORECAST)

Is there anyway we can achieve this without using a conversion file mapping?

Below is the modify script of the DM package:

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:",,,Global_IP_Upload_Transf.xls)

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

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.",1,{"Yes, check for work status settings before importing"},{"1"})

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%)

Attachments

cat.png (12.3 kB)