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

[former_member617023]

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

[former_member186338]

Please! Please!

Look on your post results after posting!

Line breaks are missing in the advanced script text.

[former_member617023]

Hi Vadim,

Thanks for the information, We realize that Conversion file option is the way to go here.

I will close the discussion.

[former_member186338]

Sorry, but using conversion file in this case is a wrong solution!

P.S. And not related to your requirements...

[former_member617023]

Hi Vadim,

Yes i have already used a package link with set prompt option, but we are wondering about this as users can easily make changes to the category selection

Do you see any other option?

[former_member186338]

Once again!!!

If you want an answer - please provide full info: full list of parameters - fixed or user selectable

If you don't want to provide full info then it's not possible to help you.

"Do you see any other option?"

I see a lot of options...

[former_member186338]

Easy solution - use package link and save selection prompt!

If you want to fix some parameters and let user to change other parameters you have to clearly explain what do you want to achieve (full list of parameters - fixed or user selectable)