Roundtrip Control | }APQ C3 FIN Roundtrip Control cube stores the roundtrip configurations and is used as basis for roundtrip orchestration. | |
Roundtrip Configuration | Set of roundtrip processing steps in the Roundtrip Control Cube with defined goal. For example hardcoding of source system data into FIN General Ledger cube. | |
Main Roundtrip Wrapper | Process }APQ.C3.FIN.Roundtrip.Main is a master process used to run selected Roundtrip Configuration implementing parameters prioritization and process synchronization as each of the roundtrip processing steps are run independently by RunProcess to avoid possible commit deadlocks. This implies commit is done after each Roundtrip Step is finished, traditional rollback mechanism applied to all child processes called from a wrapper doesn’t apply in this case. The wrapper supports running of parallel enabled roundtrip compatible processes either natively or through a compatible wrapper. Multi-year data processing is supported as the wrapper exposes pPeriodFrom and pPeriodTo parameters relating to T Year-Month dimension. The year-end rollover is handled in a sequence by the wrapper automatically should the above parameters span multiple years. | |
Roundtrip Step | Dimension }APQ C3 FIN Roundtrip Step contains basic building blocks of Roundtrip Configuration. The Roundtrip Steps are executed sequentially from the Main Roundtrip Wrapper. The Roundtrip Step may be linked either with a roundtrip compatible process or any process that can be called through a roundtrip compatible step execution wrapper. Roundtrip Compatible Process exposes set of roundtrip compatible parameters and implements semaphore logic signaling process termination to the main roundtrip wrapper. Roundtrip compatible process wrapper allows to plug-in non-compatible process with some limitations regarding custom parameters that are not compatible with roundtrip as these are allowed to receive only constant predefined values. Roundtrip Step allows to define default parameter values of the Roundtrip Compatible Parameters in relation to a Roundtrip Configuration. | |
Roundtrip Compatible Parameters | The parameters are linked to each Roundtrip Step and are passed to associated process following the prioritization logic described below. The Roundtrip Compatible Parameters are following: The parameter values follow a specific hierarchy of precedence, ordered as follows below. This hierarchy ensures that more explicit or specific parameter values are prioritized over more general or default ones. The highest priority is given to the Forced Parameter Value if it's explicitly defined by a Roundtrip Step within a Roundtrip Configuration. Next in line is the Forced default Parameter Value of a Roundtrip Step if it's explicitly set. The third level of priority is assigned to the parameter value provided via the Main Roundtrip Wrapper when executing a Roundtrip Configuration. The last priority is given to the default parameter value of the process that is linked to the Roundtrip Step. Forced Parameter Value is setting the parameter value explicitly by adding prefix FORCE: to the parameter value. Example: pVersion – FORCE:ACT The parameters pYear, pMonthFrom, and pMonthTo can be adjusted by the Main Roundtrip Wrapper if processing over multiple years is necessary. The Main Roundtrip Wrapper does this by converting its own parameters, pPeriodFrom and pPeriodTo, into values for pYear, pMonthFrom, and pMonthTo. It then iterates through each year within the selected period and adjusts these parameters as required. | |
Process Message Cube | }APQ Process Response Message cube is an important part of the solution. Provides feedback to the user. Serves as a semaphore cube to indicate process termination to the Main Roundtrip Wrapper. | |
Process State Polling | This is technique used in the Main Roundtrip Wrapper to periodically check status of a Roundtrip Processing step that has been executed. The interval is configurable in Administration > System > Settings. Select Apliqo FPM Params \ Thread polling interval (seconds) parameter. Setting polling interval to very low value is not recommended as the lower the value the bigger risk of process locking occurring. The polling is based on issuing commit to Process Message Cube, query to process state and waiting for specified period. This waiting loop is executed for limited time period and error terminating Main Roundtrip Wrapped processing will be raised if the process did not acknowledge process status change. There are two phases of polling for process execution status.
|
Manage space
Manage content
Integrations