Skip to Content
0
Former Member
Jul 27, 2016 at 10:51 AM

Load data from Bw into BPC using prompt in Dynamic script

209 Views

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