Rollup ApliqoC3 Technical Rollups

This rollup contains C3_FIXED_ACCOUNTS and C3KPI_KPI rollups. The C3_FIXED_ACCOUNTS rollup contains list of fixed accounts, while ach fixed account is representing a symbolic account with a special meaning and can be assigned a member account. When the member account is assigned, the account will become a child of the fixed account.

The C3KPI_KPI Rollup encompasses a variety of sub-rollups, each of which groups together KPIs of similar significance to enhance readability. Each KPI might be assigned up to 4 member accounts, movement and time analysis types depending on assigned calculation method.

The calculation methods are predefined and are handled both in FPM TM1 model and in Splicer. Splicer is responsible to generate rules for KPIs that can’t be implemented as rollups (simple addition or subtraction).

New calculation method might be added by adding a new corresponding element to }APQ C3 Calculation Type dimension, then updating its subset All N Elements and then adding the method to kpi_template.json configuration file of Splicer.

The calculation code template must be added to code_template object and its key must correspond with the element added to }APQ C3 Calculation Type. Value determines actual calculation in TM1 rule notation, while individual members are identified as {A}, {B}, {C} and {D}.

Open

As outlined above, simple addition or subtraction operations are not subject to KPI rule generation by Splicer. The calculation methods that are excluded from rule generation are specified in the suppress_gen object within the kpi_template.json configuration file.

Open