Date Prompt in Data Manager Package

vsb1 · ‎2019 Jul 31

Dear BPC Friends

I have a data manager package that load transection data from BW InfoProvider. The user need to first select the InfoProvider and then click ‘Set Selection’ to select Fiscal year/period (format YYYYMMM).

The user want ‘TIME’ to be a prompt. So they don’t want to click ‘Set Selection’ and select time in BW format. What they want is to be have a ‘TIME’ dimension prompt and select the month for the data load.

How can I make this happen. Given below is my DMP script and Transformation file.

*OPTIONS FORMAT = DELIMITED HEADER = YES DELIMITER = , AMOUNTDECIMALPOINT = . SKIP = 0 SKIPIF = VALIDATERECORDS=YES CREDITPOSITIVE=YES MAXREJECTCOUNT= ROUNDAMOUNT= *MAPPING ACCOUNT=0GL_ACCOUNT(5:10) CATEGORY=*NEWCOL(Actual) RPTCURRENCY=*NEWCOL(LC) SEGMENT=*IF(0SEGMENT=*STR() THEN *STR(C)+0COMP_CODE+*STR(.S9999);*STR(C)+0COMP_CODE+*STR(.S)+0SEGMENT(7:10)) GROUPS=*NEWCOL(G_NONE) FLOW=*NEWCOL(F_ACT) COMPANY_CODE=*STR(C)+0COMP_CODE TIME=0FISCPER(1:4)+*STR(.)+0FISCPER(6:7) AUDITTRAIL=*NEWCOL(BW) PROFITCENTER=*IF(0PROFIT_CTR=*STR() THEN *STR(P999999);*STR(C)+0COMP_CODE+*STR(.P)+0PROFIT_CTR(5:10)) INTERCO=*IF(0PCOMPANY=*STR() THEN *STR(ICNONE);0PCOMPANY=*STR(ALNONE) THEN *STR(ICNONE);*STR(IC)+0PCOMPANY(3:6)) AMOUNT=0SALES *CONVERSION SEGMENT=MAPPINGS.xls!SEGMENT PROFITCENTER=MAPPINGS.xls!PROFITCENTER

DMP Script

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,\ROOT\WEBFOLDERS\TMS_CONSOLIDATION\CONSOLIDATIONS\DATAMANAGER\TRANSFORMATIONFILES\TRANSACTION DATA\BW_BPC_LOAD_CONSOLIDATIONS_NEW.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,2)

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 for your help

former_member186338 · ‎2019 Aug 01

First: there is a time format issue - for infoprovider you have Fiscal year/period (format YYYYMMM), for TIME dimension you have YYYY.MM.

Then it's not possible: "What they want is to be have a ‘TIME’ dimension prompt and select the month for the data load."

You can use COMBOBOX prompt with a fixed list of YYYMMM values for some years instead.

https://blogs.sap.com/2014/09/19/dm-promptcombobox-behavior-in-bpc-nw-10-and-75/

The rest can be fixed in DM advanced script code.

Date Prompt in Data Manager Package

Know the answer?

Need more details?

Accepted Solutions (0)

Answers (1)

Answers (1)