Load data from Bw into BPC using prompt in Dynamic script

[Former Member]

Hi Experts,

I am trying to pass a variable using Prompt (for Entity Dimension) when loading data from BW into BPC.

we have used the standard SAP package "Load InfoProvider Selections" which calls the process chain /CPMB/LOAD_INFOPROV_UI.

I reviewed the previous posts but still have issues.

Any help would be appreciated.

Please see below for DM script.

PROMPT(TEXT,%ENTITY1%,"Select Entity",,)

INFO(%S1%,</LowValue><HighValue /></Attribute><Attribute><ID>%ENTITY1%</ID><Operator>3</Operator><LowValue>)

'ENTITY SELECTION

INFO(%TEMPNO1%,%INCREASENO%)

INFO(%ACTNO%,%INCREASENO%)

'DEFAULT THE INFO PROVIDER

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

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

TASK(/CPMB/INFOPROVIDER_CONVERT,TRANSFORMATIONFILEPATH,\ROOT\WEBFOLDERS\TESTAPP\B_TEST\DATAMANAGER\TRANSFORMATIONFILES\ZBPC_LOAD.XLS)

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

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

TASK(/CPMB/INFOPROVIDER_CONVERT,FILE,ZBPC_MAT)

TASK(/CPMB/INFOPROVIDER_CONVERT,INFOPROV_SELECTION,%S1%)

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)

Regards

Sathish

[former_member186338 · Accepted solution]

Sorry but I have explained it number of times! Why not to use search?????

For %SELECTION% you have to use FULL string

[former_member186338 · Accepted solution]

Look on my last answer here:

[Former Member · Accepted solution]

Hi Vadim

Thanks for reply.

I have used your previous posting itself to pass prompts.

you said to me For %SELECTION% i have to use full string, and also I have seen you specified attribute id, does it a temp name or dimension id?

My DM Script: Prompt only for one dimension

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

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(%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\AEL\B_TEST\DATAMANAGER\TRANSFORMATIONFILES\ZBPC_BOM_RECIPE_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,ZBPC_BOM)

TASK(/CPMB/INFOPROVIDER_CONVERT,INFOPROV_SELECTION,%S2%%ENTITY%)

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)

Please tell me what I am doing wrong on the above code.

When I run package with above code I am getting below error

Task name CONVERT:

No 1 Round:

An exception with the type CX_ST_MATCH_ELEMENT occurred, but was neither handled locally, nor declared in a RAISING clause

System expected element 'Selections'

Regards

Sathish

[former_member186338 · Accepted solution]

Sorry, but you are not reading my messages... And doing strange mistakes... like: INFO(%S1%... and ...INFOPROV_SELECTION,%S2%%ENTITY% - where do you have %S2%?

First you have to run unmodified package, perform the required selection and in the view status copy the whole selection string to notepad. Then find the value you want to change and split the string...

Try to look on my sample once again... and once again!

[Former Member · Accepted solution]

sorry I wrongly typed type %S1% in info seciton when posting my query, It should be %S2%

I have run unmodified package without any prompts this morning. It was working fine.