Value Driver Tree Options

Clear Logic

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

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

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

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

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.

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

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.

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.

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 to save input data or run a 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.