Options

Clear Logic

Clear Logic allows you to establish rules for clearing data in your VDT, helping you manage and manipulate data effectively.

Clear Logic

To set up Clear Logic in VDT, follow these steps:

Step 1: Navigate to the Preferences option located on the Level 2 Header. This was formerly labeled as Parameters.

Step 2: Inside the Preferences, locate and check the Enable Clear Logic option.

Step 3: After checking the Enable Clear Logic option, you can proceed to insert and define clear rules. This process is similar to setting up a Standard Calculation - Clear within the Task settings.

Interim step

The Interim Step function within the Value Driver Tree signifies that a particular metric serves as an intermediate step in reaching the final result. As such, there's no need to post the result of this metric into the model at the end of the calculation. This approach effectively reduces the redundancy of data and enhances the overall performance of the calculation process.

Interim Step

Step 1: Access any VDT Metric with a Formula method. In the upper right corner of the Formula box, you will find a checkbox labelled Interim Step. Enable the checkbox by checking it.

Step 2: Save the metric to confirm the change.

Velocity Engine

The Velocity Engine is an in-memory calculation engine that uses application resources to efficiently calculate and process large volumes of data.

Velocity Engine

To enable the Velocity Engine for a Value Driver Tree, users can simply click on Use Velocity Engine within each Value Driver Tree Step under the Calculation Task.

Data Locking by Version and Time

The Data Locking feature is intended to prevent accidental modifications to data during specific time periods. This functionality is applicable when saving data to input forms and calculation rule engines including :

• Automatic Journal

• Value Driver Tree

• Currency Conversion

• Account Mapping

• Account Reclassification

• Allocation

• Intercompany Elimination

• Dataflow

• Standard Logics (Clear/Move/Copy)

• Data Upload

To enable data locking, go to Model Schema, then Reference, and check the Allow Data Locking checkbox.

Data Locking

The following System Properties should be set up to use this feature :

• TIMEID in Time Field Type: This identifies the time sequencing property.

• EDIT_FROM and EDIT_TO (linked to Time) in Scenario Field Type: These properties define the allowed periods for each version.

After the setup, if you attempt saving input data or running calculation during a period that is not allowed for the selected version, you will see an error message indicating that the Version-Time combination is not permitted for posting.