BPC Package: TRIGGER_BW_CHAIN does not add data to InfoProvider (Cube)

[McGreger]

Dear Experts,

We use BPC NW 10.0 with SP9 and EPM-AddIn 19.

I'm trying to load transactional data from ERP --> BW in preparation to import these values into the BPC later.

therefore i created a process chain in SAP BW to trigger this process.

I now want to trigger this process chain using the Data Manager in EPM.

I created a package using /CPMB/TRIGGER_BW_CHAIN.

When executing the Package, the process chain is triggered(!) but no data will be added to the InfoProvider. The DTP ends up in a deadlock without returning error or succesful.

When triggering the process chain using normal BW backend in RSPC the process ends up succesfull

My process chain looks as follow:

I already looked SCN for a similar problem without success.

Do you have any suggestions how to solve this problem? Are there any specifics I have to consider when using /CPMB/TRIGGER_BW_CHAIN?

Kind Regards

Eric

[former_member190501 · Accepted solution]

Hi,

Try SAP Note 2157576  - BPC : NW : TRIGGER_BW_CHAIN does not finish

Hope it helps..

regards,

Raju

[McGreger · Accepted solution]

Hi Raju,

Thanks for the response.

Using "GoTo>Settings for batch manager" for the DTP's solved the issue.

I changed the Number of parallel processes to 1 as stated in the note.

We don't have a large number of Data, therefore serial processing should be fine.

Kind regards

Eric

[Former Member]

Hi,

Please add a BPC process step at the end of the process chain. Eg, BPC clear etc.. U need  to have BPC process step in the BW process chain inroder to call from BPC DM package.

Please try this and see if works.

Thanks

Rakesh

[McGreger]

Note:

to add a BPCCLEAR Variant you have to select BPC: Delete BPC tables process chain type at the end of BW process chain and create a process chain variant, which contains two parameters:

1. IFCHAINCLOSE = Y
2. CLOSE_MODE = 1 (1 means successful;2 means warning; 3 means error)

for further information see

http://service.sap.com/sap/support/notes/1505729

Kind Regards

Eric