cancel
Showing results for 
Search instead for 
Did you mean: 

Date Prompt in Data Manager Package

vsb1
Explorer
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member186338
Active Contributor
0 Kudos

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.

jorgebl
Member
0 Kudos

Hello Vadim,

I am facing the same issue, but unfortunately this doesn't seem to work. I would really appreciate your help.

The kwy is the line:

PROMPT(INFOPROVIDERSELECTION,%InforProvide%,%SELECTION%,"Please make your selection",,)
INFO(%SEL1%,<?xml version="1.0" encoding="utf-16"?><Selections xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><Selection Type="Selection"><Attribute><ID>0CALMONTH</ID><Operator>1</Operator><LowValue>)
INFO(%SEL2%,</LowValue><HighValue /></Attribute></Selection><Selection Type="FieldList"><FieldID>0CALMONTH</FieldID><FieldID>0DATAPAKID</FieldID><FieldID>0FISCPER</FieldID><FieldID>0FISCVARNT</FieldID><FieldID>0INFOPROV</FieldID><FieldID>0LOC_CURRCY</FieldID><FieldID>0RECORD</FieldID><FieldID>0RECORDMODE</FieldID><FieldID>0RECORDTP</FieldID><FieldID>0REQTSN</FieldID><FieldID>4ZNC_CMAN-ZONC_CEBE</FieldID><FieldID>4ZNC_CMAN-ZONC_CECO</FieldID><FieldID>4ZNC_CMAN-ZONC_CLCO</FieldID><FieldID>ZNC_BUUN</FieldID><FieldID>ZNC_CANA</FieldID><FieldID>ZNC_CLCO</FieldID><FieldID>ZNC_PROD</FieldID><FieldID>ZNC_SOCO</FieldID><FieldID>ZNC_SOFI</FieldID><FieldID>ZNC_SOGL</FieldID><FieldID>ZONC_ORIG</FieldID><FieldID>ZONC_PROD</FieldID><FieldID>ZONC_SOCO</FieldID><FieldID>ZONC_SOFI</FieldID><FieldID>ZONC_SOGL</FieldID></Selection></Selections>)
INFO(%InforProvide%,ZNC_CMAN)

PROMPT(COMBOBOX,%MONTH%,"Select month",1,,{202103,202104})

INFO(%SELECTION%,%SEL1%%MONTH%%SEL2%)

When declaring the value directly using code:

INFO(%MONTH%,202103)

The package works correctly, but when using the COMBOBOX, it is not working properly because it doesn't get any records.

Could you please help me? Thanks!

former_member186338
Active Contributor
0 Kudos

jorgebl

Sorry, but I don't reply in the old posts.

Create a new question and provide details.

P.S. And please, make your post readable!