How to make custom process chain run by event with parameter?

[Former Member]

Dear experts,

I have a task to do on a hybrid SAP BPC/Oracle EMP environment.

I would like to clean selected BPC transaction data by modifying and using process chain CPMB/CLEAR. This proces chain consists of:

• BPC: MODYFY PROCESS TYPE VARIANT VALUE
• BPC: CLEAR COMMENTS FOR CLEAR
• BPC: Clear cube transaction

The concept idea is:

• 1)the selection criteria are passed from Oracle system to BPC by SAP event A with parameter. The parameter describes filter conditions for dimension members designated for clearing
• 2)event A with parameter is caught by an ABAP program which converts the SAP event parameter to global variables and triggers event B
• 3)event B is caught by CPMB/CLEAR process chain and the chain runs
• 4)The BPC: MODYFY PROCESS TYPE VARIANT VALUE process is used to pass FIELD VALUES for BPC: CLEAR COMMENTS FOR CLEAR (FIELDS NAMES: SELECTION, COMMENTUSERS, CHECKJOUR) and BPC: Clear cube transaction (FIELDS NAMES: SELECTION, KEYDATE, DUMPLOADMODE, ACT_FILE_NO). The parameters are set by global variables.

Is this concept doable?

[former_member186338]

Look on the abap code of the program:

UJD_TEST_PACKAGE

It's doing what you want!

[meenakshi_palaniappan2]

May be this can be handled by DMP on BPC side itself? And you can just trigger the DMP by process chain variant?

[former_member186338]

Sorry, but the required logic is absolutely not clear!

Try to explain once again! Better from the business point of view first!

[Former Member]

Ok, Vadim. I’d describe it from different perspective.

We load data form file to SAP BPC. The process is run manually right now and it look like these:

• 1)We place the data file into a proper localization on SAP BPC server
• 2)We clean data: using excel we run CPMB/CLEAR package. In the package prompt we select dimension members for clearing, on which the data from files will be loaded.
• 3)We load data: using excel we run package CPMB/IMPORT

What we want to do is to run steps 1-3 automatically as part of a bigger process run on external server.

Is it possible to select dimension members for clearing, by passing sapevent parameter to CPMB/CLEAR package? How to do that?

[former_member186338]

"In the package prompt we select dimension members for clearing," - how do you want to automate the selection logic?? Based on import file data? or??

[Former Member]

We would like to automate selection logic, by using sapevent parameter.
We can run the process chain by using sapevent and we can sent a parameter with sapevent.
We have a concept idea to:
1) pass selection logic in sapevent parameter
2) make a abap program to interpret the sapevent parameter and store it in format that is readable for CPMB/CLEAR
3) modify CPMB/CLEAR to make it read the selection logic