Solved: Default InfoProvider and Parameters for Data Manag...

Eyal_Feiler · ‎2016 Mar 08

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

former_member186338 · ‎2016 Mar 08

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

former_member466150 · ‎2016 Mar 08

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

By Category

Related Content

Activity Groups

Industry Groups

Influence and Feedback Groups

Interest Groups

Location Groups

Customer Only Groups

Forums

Related Resources

Products

Learning and Support

About

My Account

My Account

Default InfoProvider and Parameters for Data Manager INFOPROV_UI

Know the answer?

Need more details?

Accepted Solutions (1)

Accepted Solutions (1)

Answers (1)

Answers (1)