How to Intergrate BW-BPC process chains

[Former Member]

Hello Experts,

I am trying to Integrate BW and BPC process chain. Any usefull document or links or instructions are highly apperciated. I am just confused on how & where to start.

Kali

[Former Member · Accepted solution]

Start from this excellent blog post http://scn.sap.com/people/pravin.datar/blog/2009/01/26/running-bpc-process-chains-within-non-bpc-pro...

[Former Member · Accepted solution]

Hello PM,

Thank you very much for your response but i tired all the inputs in that blog but somehow its not working and getting error 'Package Failure'.

[Former Member · Accepted solution]

Please refer,

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/00380440-010b-2c10-70a1-e0b431255...

Lucas

[Former Member · Accepted solution]

Hello Lucas,

Thank you very much for your valuable inputs but we are on BPC 10.0 but this document on BPC 7.0.

Regards,

Kali

[Former Member · Accepted solution]

Dear kali,

I'll show you a simple example of what I'm doing, hope it helps.

In order to execute a light optimize in a BW process chain you just need a very basic process chain with a starter and an abap task.

In the abap task you'll call program UJD_TEST_PACKAGE with an appropriate variant defined in SE38 (see image)

the XML fragment is:

<SCHEDULING><IMMEDIATE>Y</IMMEDIATE><STATE>0</STATE><PERIOD>N</PERIOD></SCHEDULING>

collected as described in the blog I linked.

User ID is a valid BPC user able to run the light optimize

Hope it helps

[Former Member · Accepted solution]

Hello PM,

Agian thanks lot for your inputs but i did as you said beove like using UJD_TEST_PACKAGE program to trigger the process chian but i am getting package failure.

And in you above screen shot answer prompt is empty &. how do we give answer prompt?

[Former Member · Accepted solution]

Hi kali,

please try first to run light op through Process Chain in order to be sure of the user and general setup.

An example for answer prompt is the following

%SELECTION%#/GLOBALHR/HRPLANNING/PrivatePublications/BPC_USERNAME/TempFiles/FROM.TMP@@@SAVE@@@@@@EXPAND@@@|DIMENSION:CATEGORY|CAT_NAME|

where BPC_USERNAME is the bpc username mentioned in my previous screenshot and the rest is passing parameter CAT_NAME for CATEGORY

[Former Member]

1. Create BPC Package

2. Put code on Dynamic Script to call LGF file

3. Put code on Script Logic to call BADI

4. Go to SE18, and click Display with Enhancement Spot: UJ_CUSTOM_LOGIC

5. Implement custom BADI

6. In scope of Method IF_UJ_CUSTOM_LOGIC~EXECUTE write code to call Process Chain

7. Create Process Chain ( before this you have to create its process component )

[sap_user62]

I had this issue some days back, and I was able to successfully get it working.

See this below if it helps

http://scn.sap.com/thread/3340686

Thanks

El.

[Former Member]

Hello Richard,

Thank you very much for ur response and its really helpful. But i am trying to trigger UJD_TEST_PAKCAGE program from normal BW process chain to trigger BPC load.

And also need your assitance to trigger /CPMB/LOAD_INFOPROVIDER process chain from normal BW chain if it is possible.

Kali