Process Chain /CPMB/LOAD_INFOPROV_UI

[deepesh_kumar]

Hi All,

I have activated this Process chain and as per the documents available it would provide me a interface to select needed dimensions. However when I checked the Data Manager Dynamic Script, I could not find Prompts for any user selection.

Do we need to add the prompts, or should it come by default.

Has anyone used this before? Please share thoughts.

Kind regards

[former_member223749 · Accepted solution]

Hi,

Add below lines to set dimension selection, it will not come by default.

PROMPT(INFOPROVIDERSELECTION,%InforProvide%,"%SELECTION%",Please input the infoprovider and set selection. Also be notified that navigation attribute selection on virtual provider is not supported by current BPC version.,,)

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

Hope this will help you

Thanks,

Devi

[former_member215589]

Hi Deepesh,

You can add this in modify script>advance

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,%DATATRANSFERMODE%,"Data-transfer Mode",10,{"Aggregate overwrite","Append"},{"10","9"})

PROMPT(RADIOBUTTON,%CLEARDATA%,"Select the method for importing the data from the source file to the destination database",0,{"Merge data values (Imports all records, leaving all remaining records in the destination intact)","Replace && clear datavalues (Clears the data values for any existing records that mirror each entity/category/time/datasource combination defined in the source, then imports the source records)"},{"0","1"})

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"})

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

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

TASK(/CPMB/LOAD_IP,DATATRANSFERMODE,%DATATRANSFERMODE%)

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

Regards,

Priyanka Singh

[raghu_ram]

Hi Deepesh,

Please check the SAP Note 1503897 for info. on CPMB/LOAD_INFOPROV_UI

Regards,

Raghu

[Former Member]

Hi Deepesh,

the only sting you need in the modify script is the following:

PROMPT(INFOPROVIDERSELECTION,%InforProvide%,%SELECTION%,"Please select the InfoProvider and set selection,,")

When you execute the package, you just need to insert the technical name of the Infocube you want to load from and then you have to press the "Set selection" button you find in the same prompt.

You'll then be able to filter and set selection according to the Infocubes attributes and values.

Hope it helps

Best regards

Michele