Can Infrprov and selections be hardcoded thorugh DM package in BPC?

[Former Member]

Hi Experts,

I have a requirement where the users would like to see the following -

1) Infoprov automatically populated as they launch the DM package. The package i am using is of type - /CPMB/LOAD_INFORPOV_UI -

I have hardcoded the transf file and other selections as below -

PROMPT(INFOPROVIDERSELECTION,ZIP_CP01,%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",2,{"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"},{"0","1"})

PROMPT(RADIOBUTTON,%CHECKLCK%,"Select whether to check work status settings when importing data.",0,{"Yes, check for work status settings before importing","No, do not check work status settings"},{"0","1"})

PROMPT(KEYDATE,%KEYDATE%,"Key date",0)

INFO(%INFPROVIDER%,%InforProvide%)

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

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

2) I don't know if this is possible without using a selection file, but can it be hardcoded like below when they select the box - Set Selection?

Thanks,

Lavanya

[former_member186338 · Accepted solution]

The standard prompt:

PROMPT(INFOPROVIDERSELECTION,%InforProvide%,%SELECTION%,"Please select the InfoProvider and set selection (InfoProvider list is restricted by both BW and BPC authority)",,)

Do not have parameter to specify default infoprovider!

You can't fix infoprovider in this prompt.

You can avoid this prompt completely, but in this case you will have to fix both %InforProvide% and %SELECTION%

For %SELECTION% you can add some flexibility using additional variables with COMBOBOX Prompt.

[former_member186338 · Accepted solution]

P.S. %SELECTION% variable has to contain xml text string like in log.

[Former Member]

Oh Ok Vadim, I understand.

After selecting the info provider, I thought of hard coding the selections with the script you sent above. (If that does now work, we will use the Selection file)

The bigger problem was of populating the Info Provider automatically (since we do not want users to select another provider), If there is no solution for this one, then its ok 🙂

[former_member186338]

No, you didn't understood...

Have to repeat 3rd time:

If you use:

PROMPT(INFOPROVIDERSELECTION,%InforProvide%,%SELECTION%,...)

then you can do nothing!

If you fix both infoprovider and selection then it will work somehow!

For selection you can make it partly fixed.

P.S. Please accept the correct answer.

[Former Member]

Hi Vadim,

When a user launches the DM package, he would have to click the yellow box to the right, and then search for his Info prov.

Instead of clicking on the yellow box to search the Info prov, Ideally we want it to always have a default info provider (ZIP_CP01) which should be populated as they launch the package.

Is this achievable?

[former_member186338]

Looks like you don't read my answers 😞

I have already told you:

"You can't fix infoprovider in this prompt.

You can avoid this prompt completely, but in this case you will have to fix both %InforProvide% and %SELECTION%"

[former_member186338]

P.S. What do you want to select after selecting infoprovider?

[Former Member]

Hi Vadim,

Ok the above shows combo box for info object selections (Account, Entity, fiscalper etc) which we are trying to achieve instead of using a selection file.

Is there any way i can put combo box for Info provider also in my existing Data Manager?

How can i modify the script in 'Advance' to achieve this? Can you please show me this as well?

[former_member186338]

Sorry, but I do not understand your requirements!

What do you want to allow user to select!

Provide clear example

[Former Member]

OK Vadim, Noted.

Can i use COMBO BOX selection in the above script and modify it? I checked your blog on COMBO BOX, but it seems to be only for Logic Script DMs.

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

[former_member186338]

COMBOBOX is not related to logic script DM's

It's just a way to provide user selection from the fixed list!

For example in the log you have:

InforProvide = XXXXXXX
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>0CALDAY</ID><Operator>3</Operator><LowValue>20170801</LowValue><HighValue>20990101</HighValue></Attribute></Selection><Selection Type="FieldList"><FieldID>/PKG/FP_ACCT</FieldID><FieldID>/PKG/FP_CCN</FieldID><FieldID>/PKG/FP_COOR</FieldID><FieldID>/PKG/FP_PCN</FieldID><FieldID>/PKG/FP_TDP</FieldID><FieldID>0BAL_FLAG</FieldID><FieldID>0CALDAY</FieldID><FieldID>0CALMONTH</FieldID><FieldID>0CHNGID</FieldID><FieldID>0CHRT_ACCTS</FieldID><FieldID>0COMP_CODE</FieldID><FieldID>0CO_AREA</FieldID><FieldID>0CURTYPE</FieldID><FieldID>0FISCPER</FieldID><FieldID>0FISCPER3</FieldID><FieldID>0FISCVARNT</FieldID><FieldID>0FISCYEAR</FieldID><FieldID>0FUNC_AREA</FieldID><FieldID>0RECORDTP</FieldID><FieldID>0REQUID</FieldID><FieldID>0SOURSYSTEM</FieldID><FieldID>0VERSION</FieldID></Selection></Selections>

You can see 0CALDAY selection:

<Attribute><ID>0CALDAY</ID><Operator>3</Operator><LowValue>20170801</LowValue><HighValue>20990101</HighValue>

For example, value 20170801 can be selected in some variable with combobox from some fixed list. Then %SELECTION% can be combined from fixed text and variable with user selection.

INFO(%SELFIX1%,<?xml version ... <LowValue>)
INFO(%SELFIX2%,</LowValue ... </Selection>)
PROMPT(COMBOBOX,%STARTDATE%,"Select start date",0,20170801,{20170801,20180801,20190801,20200801,20210801})
...
TASK(/CPMB/INFOPROVIDER_CONVERT,INFOPROV_SELECTION,%SELFIX1%%STARTDATE%%SELFIX2%)

Hope it's clear!