Controls

Use

Controls can be applied to any type of data. For example, a control can be used to check whether assets equal liabilities for data entered in data entry schedules or for adjustments entered in journals.

Controls are run on the data available in the model in loaded data (local currency), translated data, or consolidated data, on base entities. If a dimension is deleted from the model, all control results relevant to that dimension are also deleted.

Controls are grouped into control sets.

The main steps to follow when setting up your controls are as follows:

Control steps
Location	Step	Additional Information
Business Planning and Consolidation Administration	1. Associate a level to each entity in the entity dimension
	2. Enable controls for a selected model
	3. Create controls	Define control level, tolerance threshold, expression, and so on.
	4. Create control set and add controls
	5. Assign control set to Category/Time combination
Consolidation Central	6. Run controls	Only controls in the control set with a level less than or equal to the level of the Entity are run.
Consolidation Central	7. Monitor controls

Note

An entity for which no control level is defined is automatically assigned a control set status of Level 4, meaning all controls are run when a control set is executed.

You manage controls in Start of the navigation path Planning and Consolidation Administration Next navigation step Rules Controls End of the navigation path .

You execute controls in Start of the navigation path Consolidation Central Next navigation step Controls Monitor End of the navigation path . You can also execute tasks in a business process flow, provided that the relevant tasks are set up in the business process flow definition.

Prerequisites

To view the Controls page in Planning and Consolidation Administration, you must have the View Controls Manager right. You can go to Start of the navigation path Security Next navigation step Task Profile End of the navigation path to create and assign corresponding tasks to teams or users.

Features

A control has two output values:

The calculated amount for the control

Controls are calculated at the Entity level in loaded data (local currency), translated data, or consolidated data.
The control status

When a control set is executed, the status is a roll-up of the status of all the controls available in this set. If any problems are detected when the controls are run, warnings or errors are generated. A warning does not prevent the data from being validated in the workflow. A blocking error prevents the data from being validated, meaning the work status cannot be modified for the corresponding category, time and entity members. For more information, see Control Set Status.

Enable controls

Controls can be enabled or disabled at the model level in Planning and Consolidation Administration.

Before enabling controls, make sure the Entity dimension contains two properties: Control Level and CTRL_CURRENCY_NOT_LC (Bypass LC in Ctrls)

Note

To enable controls, work status dimensions must be set with at least three main dimensions: Category, Time, and Entity. For more information, see Create a Control.

When enabling controls for a model, you can choose whether the context of the control monitor is derived from the work status or set manually. You can also set the context of the control monitor on the parent node by selecting the checkbox Parent Node Enabled while choosing dimensions. After that you will be able to run controls against all leaf nodes under the parent node.

Edit Assignments

A control set must be assigned to a Category/Time dimension pair to be executed. For more information, see Assign a Control Set.

You can have dynamic control on work status by using the Derive from Work Status option. This allow users to change a work state in Consolidation Monitor even though a failed result exists. All selected work statuses cannot be changed when there is a failed result; the control result must be checked and reviewed. However, any unchecked work status can be changed even though a failed result exists.

Activities

To enable controls
1. In the Controls page, select the model whose control sets you want to enable.
2. Select Enable controls.
3. Define under which context you want to run controls by choosing Derive from Work Status or Select Dimension.
  - If you choose Derive from Work Status, the context bar of Control Monitor will be made up of the driving dimension and other dimensions of the corresponding work status.
    
    By default settings, if you failed to run a control, you cannot change any work statuses until the control passes the check. To offer more flexibility, you can still change one or more work states in Consolidation Monitor even though a failed result exists by unchecking the corresponding work states.
  - If you choose Select Dimension, the context bar of Control Monitor will be made up of the selected dimensions.
    
    If you select the checkbox Parent Node Enable for a dimension, you will be able to run controls against the parent node and all its leaf node members in Control Monitor. If you do not select the checkbox Parent Node Enable for a dimension, you will not be able to select parent node members of the dimension to run Control Monitor.
4. Click Save to save the settings.
To display the Controls page in Planning and Consolidation Administration, select Rules Controls.
To display a control definition:
1. In the Controls page, select the model containing the control(s) you want to view.
2. In the Controls for <Model name> page, click an individual control to display its properties.
To edit assignments for a control set, see Assign a Control Set.