CoA Orchestration

The CoA framework is designed to streamline the orchestration of routine tasks involved in constructing both operational and planning CoA dimensions, enabling the process to be easily repeated on a regular basis.

The orchestration mechanism is based on sequence of steps that are bound to each target dimension in }APQ C3 FIN CoA Rollup Control cube. Each step represents one process manipulating the CoA dimension. Each process is assigned a sequence ID and set of parameter values in the context of target dimension update. Sequence ID corresponds to order in which the process will be called from a wrapper process }APQ.C3.Dim.CoAMap.Dimension.Import.Main that provides the CoA orchestration.

Open

It is important to understand the wrapper process is running each step as part of a single transaction, so all changes are committed only after the entire wrapper process has been executed. This is a key distinction from the roundtrip wrapper, which treats each step as an independent transaction and commits changes at the end of each individual step execution.

Adding a New Custom Step

You may add a custom process as new step to the CoA orchestration framework through selection of Run a custom process option from the Process entry. This will allow you to select custom process from Call Process field. Parameters that are available in }APQ C3 FIN CoA Rollup Control Measure have to be entered directly, other parameter values need to be entered through pParamArray parameter field. The parameters should be formatted as follows: each parameter is represented by its name, followed by a colon, and then its value. If there are several parameters, they should be divided by an ampersand.