Monthly splitting

When it is necessary to define periodic data of one or more accounts from the cumulated data of a specific period, it is possible to use CCH Tagetik's Monthly splitting data processing or the Custom Splitting on Periods data processing .

The first one (Monthly splitting) is defined for each single account and allows you to split per month from the last period of a scenario, on all previous periods of the Scenario, while the second one (Custom Splitting on Periods) allows you to define in much more detail the data to split, the Scenarios /Periods on which to split the data and the driver to use

In order to use the Monthly splitting, it is necessary to define some rules which are not linked to a specific process nor to an entity, but to the account to which the amount to be split belongs.

The monthly splitting rules allow the user to generate entries on the target periods.

Monthly splitting rules¶

The monthly splitting rules can be defined for the "P&L", "Other variations" accounts or for the "Variations" accounts of "BS" or "Other stocks" nature.

For the other account types / natures it is not possible to define the monthly splitting rules since they are always treated as cumulated accounts.

In order to define a monthly splitting rule, it is necessary to:

access the accounts elements table (accessible from the administrator user web interface by following the path Setup & Admin > Data Model > Dimensions > Account > Elements) Navigation panel> Dimensions > Account > Elements) and select the account for which the the monthly splitting rule has to be defined;
place the cursor on the "Monthly splitting rules" tab

The Monthly splitting type property specifies how the cumulated amount has to be split. Possible splitting types:

No. The system does not run any monthly splitting
Flat. The account's value is shared equally on each period (e.g. the amount of December is equally split on 12 months)
Coefficient 445. The account's value is distributed according to a coefficient which follows the 4,4,5 progression of the weeks during the months. Considering that in one year there are 52 weeks and that in each quarter there are 13 weeks, the "weights" of the weeks in the quarter will be 4/52 8/52 13/52 17/52 .... 47/52 52/52
Coefficient 454. The value of the account is distributed according to a coefficient which follows the 4, 5, 4 progression of the weeks during the months. Considering that in one year there are 52 weeks and that in each quarter there are 13 weeks, the "weights" of the weeks in the quarter will be 4/52 9/52 13/52 17/52 .... 48/52 52/52
Coefficient 544. The value of the account is distributed according to a coefficient which follows the 5,4,4 progression of the weeks during the months. Considering that in one year there are 52 weeks and that in each quarter there are 13 weeks, the "weights" of the weeks in the quarter will be 5/52 9/52 13/52 18/52 .... 48/52 52/52

The rules using the coefficients 445, 454 and 544 can be applied only if the monthly splitting is done on 12 periods.

Adv. management The system splits per month the value of an account using a driver. The driver to use is defined according to the following information

Reference:

the Reference account. Account used to calculate the monthly splitting driver. If none is specified, the system uses the account for which the monthly splitting rule is being defined.

As an alternative to a single account, it is possible to indicate an entire hierarchy of accounts (Reference accounts hierarchy)

the reference scenario. The definition of a reference scenario is required when the scenario to use for the calculation is different from the data processing scenario. The reference scenario for the driver is parametric, in other words determined by the system during the rule execution. The available parametric values are:

PREV. The reference scenario for the driver is the one before the processed scenario
NEXT. The reference scenario for the driver is the one after the processed scenario
REF1...REF5. The reference scenario for the driver is the 1...5 reference scenario related to the processed scenario

a possible filter on the managed custom dimensions 1…5, on the category, on theCtp entity and on the Ctp custom dimension 2 to apply when defining the monthly splitting driver

Process setup for the "Monthly splitting" management¶

In order to enable the "Monthly splitting" data processing for a given process the user needs to:

open the process elements table accessible from the admin user interface from Setup & Admin > Processes > select the process to parametrize and then Actions () > Define process. ; Navigation panel> Processes& Workflows > Process > select the process to parametrize and then Actions () > Define process. ;
in the Data Processing area, enable the Others > Monthly splitting by Account data processing
save

“Monthly splitting” data processing¶

Once the parametrization of the monthly splitting rules is complete, it is possible to run the monthly splitting data processing. This data processing can be run only if its execution has been enabled for the selected process (for further details see chapter Other data processing of the manual on the process parametrization).

The system calculates data to be split per month according to the information specified in the initial filter:

the last period of the scenario to run. In order to run the monthly splitting it is necessary to "launch" the data processing on the last open period of a scenario: usually it is run on the period 12 but, if the periods represent the weeks, it is run on the period 52. If several scenarios/periods are specified in the initial filter, the system puts together the monthly splitting periods: for example, scenarios 2010C/12 and 2010B/12 will be run together if they have the same target periods
the entities
other possible optional filters
the accounts to which a monthly splitting rule is linked

The data processing "operates" only on the gross amounts and on the IC amounts and takes into account all origins but those generated:

by a previous monthly splitting (PROC_MONTHLY_SPLIT_NEW)
by the preconsolidation reclassifications (PROC_RECLASSIFICATION)
by the depreciation calculation (PROC_DEPRECIATION)
by the basic calculations (PROC_CALCULATED_BASIC)
by the deferred taxes calculation (PROC_DEFERRED_TAXES)
by the balancing (PROC_BALANCING)
by the equity reclassification (PROC_NETEQUITY_RECL)
by the application of calculation logics (PROC_CALCULATED)
by the deconsolidation (PROC_DECONSOLIDATION3)

The system applies the monthly splitting rule to each data to be split per month, as follows:

if the "Monthly splitting type" defined for the account is "NO", then data is not split per month
if the "Monthly splitting type" defined for the account is "simple" type, then data is split per month by applying the constant coefficient specified in the rule
if the "Monthly splitting type" defined for the account is “advanced”, then the system calculates the monthly splitting drivers according to the information specified in the rule. The calculated drivers are used by the system to calculate the weights to apply to data to be split per month. Once the weights have been calculated, they can be applied to data to split per month.

Before entering the monthly splitting entries, the system removes the existing ones.

Run "Monthly splitting"¶

The monthly splitting can be run:

from the contributor user's process cockpit. After selecting one or more entities or one or more nodes, it is necessary to select the Entity data processing button from the Actions menu and then select Monthly splitting in the data processing tree under the "Entity data processing" node. This data processing is visible only if the Monthly splitting data processing is enabled for the selected process.
from a data entry form
from a workflow task
from a job task

From form¶

The "Monthly splitting" can be run also from a data entry form as a single data processing as a part of the Entity data processes enabled for a given process.

Single data processing

Open the form in Design mode, click on Data processing on the Design ribbon bar (or right click on the Open Items panel).

The system displays a window in which the user will select the data processing to run: select Monthly splitting and click on Next to set up the parameters and define the data processing execution area on the Entity, Scenario, Period and Category dimension and on the Custom dimensions. The parameters in bold are mandatory.

The parameters definition modes are:

Automatic. The system retrieves automatically the parameter's value from a form filter, a tab filter, a matrix filter, a row/column filter. If the filter is defined by a parameter (therefore its value is chosen by the user at run-time) the choice of the data processing value will be up to the user
Excel cell. The system retrieves the parameter's value from an Excel cell. The user must specify the cell containing the value by using the syntax ${H30} (cell H30).
Insert. The user must enter the parameter's value into the corresponding text box
Select. The user must select the parameter's value from a list of possible values
Cell field. The system retrieves the parameter's value from a cell field.

After setting up the parameters, click on "Next" to configure a series of options which allow the system to understand how the data processing has to be run within the form (e.g. if it has to be run upon saving or manually, for further details see Data processing).

Eventually it is necessary to assign a code and a description to the data processing that will be inserted in the form.

Entity data processing

The monthly splitting belongs to the Entity data processing and can be run also as a part of such data processing just by selecting it from the Entity data processing selection window.

In this case, the following parameters have to be set up:

the original scenario / period on which the data processing has to be run;
the entities to which data to run are allocated;
Disable impacted. By default this option is disabled.

In this case, it is not possible either to select the accounts to split per month or specify filters on the other dimensions..

From workflow¶

Tagetik allows the user to run the monthly splitting also from a workflow model task. Also in this case, it can be run in two ways, namely either as a part of the entity data processing or individually.

In this case, the process, the period and the entities to run are pre configured in the process cockpit.

Single data processing

Open the Workflow definition page in edit mode, define a new Task by dragging the Monthly splitting icon, Other data processing tab into the workflow area.

Besides the regular options of any Workflow Task, in the Parameters area it is necessary to specify the data processing execution area on the Account, Category and Custom dimensions.

Entity data processing

Define a new Task by selecting it from the top bar, in the Core data processing tab, Entity Data processing.

Select Monthly Splitting in the parameters.

In this case, it is not possible either to select the accounts to split per month or to specify filters on the other dimensions.

From job¶

Tagetik allows the user to run the monthly splitting also from a job task. Also in this case, it can be run in two ways, namely either as a part of the entity data processing or individually.

Single data processing

Open the Job definition page in edit mode, define a new Task by dragging the Monthly splitting icon, Other data processing tab;

Besides the regular options of any Job Task, in the Parameters area it is necessary to specify the Process and the data processing execution area on the Account, Entity, Scenario, Period, Category and Custom dimensions.

By selecting the All option (Entity and Scenario/Period) the values of the corresponding parameter will be determined by the system when running the job and they will coincide with all the available values, at that time, for that specific parameter.

Entity data processing

Define a new Task by selecting it from the top bar, in the Core data processing tab, Entity data processing.

In the parameters area, it is necessary to specify the process, the Scenarios / Periods and the Entities to run and then select the Monthly splitting data processing.

In this case, it is not possible either to select the accounts to be split per month or specify filter s on the other dimensions.

By selecting the All option (Entity and Scenario/Period) the values of the corresponding parameter will be determined by the system when running the job and they will coincide with all the available values, at that time, for that specific parameter.