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