How to manage sequence of functions in SAP PaPM Cloud?

[Sergio9]

I have some functions in my model that depend on several functions needing to be executed in a specific order. In particular, I need to write the output of some Join functions in different HANA model tables. I created a Writer function for each Join, and a Join function that takes all the Writers as input, in order to run all the Writers by executing just one function.

 

How can I manage and choose the execution order of functions or create a custom function execution chain in SAP Profitability and Performance Management Cloud?

 

I’ve already tried following the steps outlined in this post "How to manage sequence of functions in execution chain" (https://community.sap.com/t5/financial-management-blogs-by-sap/sap-profitability-and-performance-man...), but they aren’t working as expected.

What additional strategies or tips can you recommend?

 

Thank you in advance.

 

SAP Profitability and Performance Management

[Paulo_Moncada]

Hi Sergion,

This is not quite a chain that you want to achieve but a sequence run for each writer function. What you did is correct to have a join and run the writer functions and write to several HANA tables. But to choose the sequence, there is an option to do this in Process Template as execution activity for each writer. But this means you will need to run then independently. OR.

Use the Process Scheduler https://community.sap.com/t5/financial-management-blogs-by-sap/process-scheduler-execution-made-easy... 

You can again use your writers in an activity inside a process template and schedule their Run depending on your sequence. 1 Job/Schedule = 1 Execution Activity (writer) so they will run in the schedule that you want. 

I hope this provides a little help.

[Sergio9]

Hi Paulo,

Thanks for your input! I appreciate the suggestion of using the Process Scheduler. However, I was hoping to avoid the need for scheduling the executions at a specific time.

What I’m really looking for is a way to execute all the functions in the right order by pressing a single button - any time I need it - without setting up a timed schedule. Ideally, I’d like to configure a single execution chain where I can trigger each Writer function in sequence, ensuring each function completes before the next one starts.

Is there a way to achieve this, or perhaps any other tools in PaPM that would allow for this type of flexible, on-demand sequential execution?

Thanks again for your help!