Question Re: Default InfoProvider and Parameters for Data Manager INFOPROV_UI in Financial Management Q&A

Default InfoProvider and Parameters for Data Manager INFOPROV_UI

Eyal_Feiler — Tue, 08 Mar 2016 11:29:40 GMT

Hi Experts,

I would like to perform the following:
Default an infoProvider

Provide prompts for Entity and Time range. This is a more informed (hopefully) post from my prior -

I reviewed the previous posts but still have trouble. Any help would be appreciated.

Cube is hard coded so user does not have to choose.

I created variables for Entity and Time1 and Time 2. They don’t appear to be active since I see in my EPM report that data is being imported for multiple entities and periods regardless of the selection. Tried 2 types of selection separately - 'GF_ENT_S</ID><Operator>1</…. and INFO(%GF_ENT_S%... as per below. Each time the variables are ignored.

Please see below for DM script and the log output of the tested script below and of a successful non-coded BW import.

Any ideas to fix?

I also linked to other posts that I checked that helped get to this point.

Thank you in advance.

Regards,

Eyal

TESTED SCRIPT

'DEBUG(ON)

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

INFO(%TEMPNO1%,%INCREASENO%)

INFO(%ACTNO%,%INCREASENO%)

'DEFAULT THE INFO PROVIDER

TASK(/CPMB/INFOPROVIDER_CONVERT,FILE,GFC_TB53)

PROMPT(TEXT,%ENTITY1%, "Enter the Entity", ,)

PROMPT(TEXT,%YR_MO_1%, "Enter the starting year and mo format: YYYY.MM", ,)

PROMPT(TEXT,%YR_MO_2%, "Enter the Ending range year and mo format: YYYY.MM, or leave blank if only selecting one period ", ,)

TASK(/CPMB/INFOPROVIDER_CONVERT,OUTPUTNO,%TEMPNO1%)

TASK(/CPMB/INFOPROVIDER_CONVERT,ACT_FILE_NO,%ACTNO%)

INFO(%MAI_TRFILE%,\ROOT\WEBFOLDERS\MAI_CONSO\Consolidation\DATAMANAGER\TRANSFORMATIONFILES\EXAMPLES\MA\T_FILE_BW_IPROVIDER.XLS)

TASK(/CPMB/INFOPROVIDER_CONVERT, TRANSFORMATIONFILEPATH , %MAI_TRFILE%)

TASK(/CPMB/INFOPROVIDER_CONVERT,SUSER,%USER%)

TASK(/CPMB/INFOPROVIDER_CONVERT,SAPPSET,%APPSET%)

TASK(/CPMB/INFOPROVIDER_CONVERT,SAPP,%APP%)

'TASK(/CPMB/INFOPROVIDER_CONVERT,FILE,%InforProvide%) – Commented to hard code above

'Entity Selection

'GF_ENT_S</ID><Operator>1</Operator><LowValue>%ENTITY1%</LowValue><HighValue /></Attribute><Attribute><ID>

INFO(%GF_ENT_S%,</ID><Operator>1</Operator><LowValue>%ENTITY1%</LowValue><HighValue /></Attribute><Attribute><ID>)

' Time selection

'GF_TIME_S</ID><Operator>3</Operator><LowValue>%YR_MO_1%</LowValue><HighValue>%YR_MO_2%</HighValue></Attribute></Selection><Selection Type="FieldList"><FieldID>

INFO(%GF_TIME_S%,</ID><Operator>3</Operator><LowValue>%YR_MO_1%</LowValue><HighValue>%YR_MO_2%</HighValue></Attribute></Selection><Selection Type="FieldList"><FieldID>)

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

'supress prompts for work status default script and replace - default as yes and yes replace. Default transformation file path

Prior posts – I referenced

BPC Help text box

Set Default InfoProvider

Filter range Within DM

CURRENT LOG

/CPMB/MODIFY completed in 0 seconds

/CPMB/INFOPROVIDER_CONVERT completed in 7 seconds

/CPMB/LOAD_IP completed in 18 seconds

/CPMB/CLEAR completed in 0 seconds

[Selection]

--------------------------------------------------------------

ENTITY1 = 1120

YR_MO_1 = 2016.03

YR_MO_2 =

[Message]

--------------------------------------------------------------

Task name CONVERT:

No 1 Round:

Reject count: 336

Record count: 21573

Skip count: 0

Accept count: 21237

Task name LOAD INFOPROVIDER:

Suppressed zero-value records: 6,421

Replace and Clear Submit count: 9370

Replace and Clear Reject count: 0

Aggregate count: 17490

Submit count: 3747

Reject count: 0

model: Consolidation. Package status: WARNING

“GOOD LOG” of a non-hard coded cube import

/CPMB/MODIFY completed in 0 seconds

/CPMB/INFOPROVIDER_CONVERT completed in 1 seconds

/CPMB/LOAD_IP completed in 22 seconds

/CPMB/CLEAR completed in 0 seconds

[Selection]

--------------------------------------------------------------

InforProvide = GFC_TB53

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>GF_ENT_S</ID><Operator>1</Operator><LowValue>1140</LowValue><HighValue /></Attribute><Attribute><ID>GF_TIME_S</ID><Operator>1</Operator><LowValue>2015.04</LowValue><HighValue /></Attribute><Attribute><ID>GF_CTEG_S</ID><Operator>1</Operator><LowValue>RF</LowValue><HighValue /></Attribute></Selection><Selection Type="FieldList"><FieldID>0CALMONTH</FieldID><FieldID>0CHNGID</FieldID><FieldID>0RECORDTP</FieldID><FieldID>0REQUID</FieldID><FieldID>GF_ACC_S</FieldID><FieldID>GF_ACC_S__GF_EX_C1</FieldID><FieldID>GF_ACTV_S</FieldID><FieldID>GF_AI_S</FieldID><FieldID>GF_AUDT_S</FieldID><FieldID>GF_BNK_S</FieldID><FieldID>GF_CC_S</FieldID><FieldID>GF_CNTR_S</FieldID><FieldID>GF_CTEG_S</FieldID><FieldID>GF_CUR_S</FieldID><FieldID>GF_ENT_S</FieldID><FieldID>GF_ENT_S__GF_EX_C2</FieldID><FieldID>GF_FLG01</FieldID><FieldID>GF_FLG02</FieldID><FieldID>GF_FLOW_S</FieldID><FieldID>GF_ICO_S</FieldID><FieldID>GF_LDAT</FieldID><FieldID>GF_LDUSR</FieldID><FieldID>GF_LTIM</FieldID><FieldID>GF_PRD_S</FieldID><FieldID>GF_SCOP_S</FieldID><FieldID>GF_SGR_S</FieldID><FieldID>GF_SOURCE</FieldID><FieldID>GF_TC_S</FieldID><FieldID>GF_TIME_S</FieldID></Selection></Selections>

[Message]

--------------------------------------------------------------

Task name CONVERT:

No 1 Round:

Reject count: 0

Record count: 1

Skip count: 0

Accept count: 1

Task name LOAD INFOPROVIDER:

Suppressed zero-value records: 1

Replace and Clear Submit count: 3

Replace and Clear Reject count: 0

Submit count: 1

Reject count: 0

model: Consolidation. Package status: SUCCESS

Re: Default InfoProvider and Parameters for Data Manager INFOPROV_UI

former_member466150 — Tue, 08 Mar 2016 13:26:12 GMT

Hi Eylan Fieler,

Can you try by adding the below code?

INFO(%INPRO%,GFC_TB53)

'DEFAULT THE INFO PROVIDER

TASK(/CPMB/INFOPROVIDER_CONVERT,FILE,%INPRO%)

Saving the Info Provider name in the variable %INPRO% and then using this variable as input to /CPMB/INFOPROVIDER_CONVERT Process Chain Variant's Attribute(FILE).

Re: Default InfoProvider and Parameters for Data Manager INFOPROV_UI

former_member186338 — Tue, 08 Mar 2016 16:10:20 GMT

Hi h k,

It's absolutely not required to use variable to hardcode the infoprovider!

Vadim

Re: Default InfoProvider and Parameters for Data Manager INFOPROV_UI

former_member186338 — Tue, 08 Mar 2016 16:25:33 GMT

Hi Eyal,

I don't know what was the idea to open a new discussion without closing the previous one. And in the new discussion you are doing the same mistakes...

Start with original script for LOAD_INFOPROV_UI:

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

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

Select single Entity: 1140

And dates: 2 dates for the interval !

Show the log (in your log I can see only single date selected)

Vadim

Re: Default InfoProvider and Parameters for Data Manager INFOPROV_UI

Eyal_Feiler — Wed, 09 Mar 2016 10:35:41 GMT

Hi Vadim,

Here is the result of the original DM you provided.

I will close the other thread..

After running as is, I took it one step further and tried modifying – the cube selection is correct, but the variables are not. How do you suggest I modify the below syntax to add an entity range and time range?
Thanks

Eyal

Below is the result of the "original" DM you provided:

/CPMB/MODIFY completed in 0 seconds

/CPMB/INFOPROVIDER_CONVERT completed in 1 seconds

/CPMB/LOAD_IP completed in 2 seconds

/CPMB/CLEAR completed in 0 seconds

[Selection]

--------------------------------------------------------------

InforProvide = GFC_TB53

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>GF_ENT_S</ID><Operator>1</Operator><LowValue>1140</LowValue><HighValue /></Attribute><Attribute><ID>GF_TIME_S</ID><Operator>3</Operator><LowValue>2016.03</LowValue><HighValue>2016.04</HighValue></Attribute></Selection><Selection Type="FieldList"><FieldID>0CALMONTH</FieldID><FieldID>0CHNGID</FieldID><FieldID>0RECORDTP</FieldID><FieldID>0REQUID</FieldID><FieldID>GF_ACC_S</FieldID><FieldID>GF_ACC_S__GF_EX_C1</FieldID><FieldID>GF_ACTV_S</FieldID><FieldID>GF_AI_S</FieldID><FieldID>GF_AUDT_S</FieldID><FieldID>GF_BNK_S</FieldID><FieldID>GF_CC_S</FieldID><FieldID>GF_CNTR_S</FieldID><FieldID>GF_CTEG_S</FieldID><FieldID>GF_CUR_S</FieldID><FieldID>GF_ENT_S</FieldID><FieldID>GF_ENT_S__GF_EX_C2</FieldID><FieldID>GF_FLG01</FieldID><FieldID>GF_FLG02</FieldID><FieldID>GF_FLOW_S</FieldID><FieldID>GF_ICO_S</FieldID><FieldID>GF_LDAT</FieldID><FieldID>GF_LDUSR</FieldID><FieldID>GF_LTIM</FieldID><FieldID>GF_PRD_S</FieldID><FieldID>GF_SCOP_S</FieldID><FieldID>GF_SGR_S</FieldID><FieldID>GF_SOURCE</FieldID><FieldID>GF_TC_S</FieldID><FieldID>GF_TIME_S</FieldID></Selection></Selections>

TRANSFORMATION = \ROOT\WEBFOLDERS\MAI_CONSO\Consolidation\DATAMANAGER\TRANSFORMATIONFILES\EXAMPLES\MA\T_FILE_BW_IPROVIDER.XLS

TARGETMODE = 2

RUNLOGIC = Yes

CHECKLCK = Yes

[Message]

--------------------------------------------------------------

Task name CONVERT:

No 1 Round:

Reject count: 0

Record count: 36

Skip count: 0

Accept count: 36

Task name LOAD INFOPROVIDER:

Suppressed zero-value records: 5

Replace and Clear Submit count: 10

Replace and Clear Reject count: 0

Aggregate count: 30

Submit count: 6

Reject count: 0

model: Consolidation. Package status: SUCCESS

Re: Default InfoProvider and Parameters for Data Manager INFOPROV_UI

former_member186338 — Wed, 09 Mar 2016 12:33:47 GMT

Something like this:

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

PROMPT(TEXT,%ENT%, "Enter the Entity", ,)

PROMPT(TEXT,%YR_MO_1%, "Enter the starting year and mo format: YYYY.MM", ,)

PROMPT(TEXT,%YR_MO_2%, "Enter the Ending range year and mo format: YYYY.MM, or leave blank if only selecting one period ", ,)

INFO(%S1%,<?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>GF_ENT_S</ID><Operator>1</Operator><LowValue>)

INFO(%S2%,</LowValue><HighValue /></Attribute><Attribute><ID>GF_TIME_S</ID><Operator>3</Operator><LowValue>)

INFO(%S3%,</LowValue><HighValue>)

INFO(%S4%,</HighValue></Attribute></Selection><Selection Type="FieldList"><FieldID>0CALMONTH</FieldID><FieldID>0CHNGID</FieldID><FieldID>0RECORDTP</FieldID><FieldID>0REQUID</FieldID><FieldID>GF_ACC_S</FieldID><FieldID>GF_ACC_S__GF_EX_C1</FieldID><FieldID>GF_ACTV_S</FieldID><FieldID>GF_AI_S</FieldID><FieldID>GF_AUDT_S</FieldID><FieldID>GF_BNK_S</FieldID><FieldID>GF_CC_S</FieldID><FieldID>GF_CNTR_S</FieldID><FieldID>GF_CTEG_S</FieldID><FieldID>GF_CUR_S</FieldID><FieldID>GF_ENT_S</FieldID><FieldID>GF_ENT_S__GF_EX_C2</FieldID><FieldID>GF_FLG01</FieldID><FieldID>GF_FLG02</FieldID><FieldID>GF_FLOW_S</FieldID><FieldID>GF_ICO_S</FieldID><FieldID>GF_LDAT</FieldID><FieldID>GF_LDUSR</FieldID><FieldID>GF_LTIM</FieldID><FieldID>GF_PRD_S</FieldID><FieldID>GF_SCOP_S</FieldID><FieldID>GF_SGR_S</FieldID><FieldID>GF_SOURCE</FieldID><FieldID>GF_TC_S</FieldID><FieldID>GF_TIME_S</FieldID></Selection></Selections>

INFO(%TEMPNO1%,%INCREASENO%)

INFO(%ACTNO%,%INCREASENO%)

TASK(/CPMB/INFOPROVIDER_CONVERT,OUTPUTNO,%TEMPNO1%)

TASK(/CPMB/INFOPROVIDER_CONVERT,ACT_FILE_NO,%ACTNO%)

TASK(/CPMB/INFOPROVIDER_CONVERT,TRANSFORMATIONFILEPATH, \ROOT\WEBFOLDERS\MAI_CONSO\Consolidation\DATAMANAGER\TRANSFORMATIONFILES\EXAMPLES\MA\T_FILE_BW_IPROVIDER.XLS)

TASK(/CPMB/INFOPROVIDER_CONVERT,SUSER,%USER%)

TASK(/CPMB/INFOPROVIDER_CONVERT,SAPPSET,%APPSET%)

TASK(/CPMB/INFOPROVIDER_CONVERT,SAPP,%APP%)

TASK(/CPMB/INFOPROVIDER_CONVERT,FILE,GFC_TB53)

TASK(/CPMB/INFOPROVIDER_CONVERT,INFOPROV_SELECTION,%S1%%ENT%%S2%%YR_MO_1%%S3%%YR_MO_2%%S4%)

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

Not sure it will work with only single yearmonth selected...

Vadim

Re: Default InfoProvider and Parameters for Data Manager INFOPROV_UI

Eyal_Feiler — Thu, 10 Mar 2016 08:12:16 GMT

Hi Vadim,

Thank you for the clear example.

I started testing, so far looks good. I'll update.

Regards,

Eyal