/CPMB/LOAD_INFOPROV_UI modifying the script

[Former Member]

Hi, Is it possible to trigger the process chain /CPMB/LOAD_INFOPROV_UI from one model in a BPC environment in order to load data into another model?

I would like to trigger the /CPMB/LOAD_INFOPROV_UI process chain via a package in the FINANCE model and have the data loaded in the IC_MATCHING model. This is because we use a package link.  Could you let me know what line I need to change in order to do this?

Below is the script criteria of the standard script which I would need to modify

Many thanks

Colin

(INFOPROVIDERSELECTION,%InforProvide%,%SELECTION%,"Please select the InfoProvider and set selection (InfoProvider list is restricted by both BW and BPC authority)",,)

(TRANSFORMATION,%TRANSFORMATION%,"Transformation file:",,,Import.xls)

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

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

(KEYDATE,%KEYDATE%,"Key date",0)

(%TEMPNO1%,%INCREASENO%)

(%ACTNO%,%INCREASENO%)

(%KEYDATE%,)

(%RUNLOGIC%,0)

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

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

(/CPMB/INFOPROVIDER_CONVERT,TRANSFORMATIONFILEPATH,%TRANSFORMATION%)

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

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

(/CPMB/INFOPROVIDER_CONVERT,SAPP,%APP%)

(/CPMB/INFOPROVIDER_CONVERT,FILE,%InforProvide%)

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

(/CPMB/INFOPROVIDER_CONVERT,KEYDATE,%KEYDATE%)

(/CPMB/LOAD_IP,PREPROCESSMODE,0)

(/CPMB/LOAD_IP,TARGETMODE,%TARGETMODE%)

(/CPMB/LOAD_IP,INPUTNO,%TEMPNO1%)

(/CPMB/LOAD_IP,ACT_FILE_NO,%ACTNO%)

(/CPMB/LOAD_IP,RUNLOGIC,%RUNLOGIC%)

(/CPMB/LOAD_IP,CHECKLCK,%CHECKLCK%)

(/CPMB/LOAD_IP,KEYDATE,%KEYDATE%)

[Former Member · Accepted solution]

Hi Tulley,

As advised by Vadim, Either you can play in advance script or you can create a process chain in BW and add a program variant in it where you can use program " UJD_TEST_PACKAGE " to kick package of any Model. Create a package link in the source model and trigger that process chain from it.

You can also get some idea from below thread-

Hope this helps,

Regards,

[Former Member · Accepted solution]

Hi Ashish, I have gone with this approach and it has the desired objective so thankyou very much. It is strange that you cant chnage the you cant hardcode the destination cube (/CPMB/INFOPROVIDER_CONVERT,SAPP,ICMATCHING) so I am going to ask SAP but in the meantime I have a good work around. Thank you for your help.

Colin

[Former Member]

Hi Tulley,

Typically , /CPMB/LOAD_INFOPROV_UI is used to load data from BW infoprovider.

Have you tried ' Destination App'? If not then below documentation will help you load data from one model to another.

*DESTINATION_APP - SAP Business Planning and Consolidation, version for SAP NetWeaver - SAP Library

Thanks,

Varsha

[former_member186338]

Ups, looks like some misunderstanding... The topic author wants to initiate load data from BW to the cube that is not a current cube.

May be it's possible to play with:

(/CPMB/INFOPROVIDER_CONVERT,SAPP,%APP%)

Instead of %APP% use fixed model name.

But not sure...

Vadim

[Former Member]

Hi Varsha, I do need to load data from BW Infoprovider.

Regards

Colin

[Former Member]

Hi Vadim, thankyou for your reply. I have tried replacing %APP% with the model name FINANCE however that does not seem to work. The package results in a warning with zero records in the task name CONVERT stage

No 1 Round:

Reject count:0

Record count: 0

Skip count:0

Accept count: 0

I am however successuful when I load via the ICMATCHING model.

Any ideas?

many thanks

Colin

[former_member186338]

What about transformation file location - have you copied it to FINANCE model?

[Former Member]

Hi Vadim, I have tried having the transformation file in FINANCE and also ICMATCHING. Effect is the same. Interesting point is when I validate and process the transformation file in FINANCE using the transformation file saved in FINANCE, it validates with 0 records in record count, accept counSkip count and accept count.

[Former Member]

Hi Vadim, thanks for your help on this. I have gone with using the UJD_TEST_PACKAGE approach but will ask SAP if there is any way to do what we were trying to do on the SAPP hard coding and I will share the results.

thanks

Colin

[former_member186338]

What about transformation file? Do you also have conversion file?

[Former Member]

Hi Vadim, yes there is a conversion file.

[former_member186338]

Please provide full info! Full Advanced script...

And use fixed string for transformation file location! Check path to conversion file...

[former_member186338]

P.S. And provide the full log!