Skip to content

Calculation rules page

Application database > Analytical Workspaces tile > workspace tile > Data transformation package tab > Calculation rules

Application database > Navigation panel > Analytic Information Hub > workspace tile > Data Transformation Package tab > new DTP

Purpose of the page

This page allows you to define calculation rules that make it possible to perform complex calculations, working on dataset rows. In contrast, standard DTP calculation operations process transformations in column mode. It is divided into two tabs: Script and Logical dimensions. In both tabs, it is possible to work using the "spreadsheet" function, which allows you to view and edit data, like in an Excel sheet.

Script attributes tab

Element Description
Code Code of the calculation script. Must not contain special characters. Follows the same rules as used for the application's code fields.
Description Description for the various languages defined for the user.
Script Script that defines the calculation rule. Expand the field to make the formula easier to read.
Label Unique code used to group rules. Can be used during the definition of the DTP operation, to run all rules with the same label.
Enable If selected, it allows the rule to be used during the execution of a DTP. Selected by default.
Run condition Allows you to enter, as an SQL formula, the condition to be checked in order to run the script. If not specified, the script is always run.
Start date Allows you to specify whether the script has a start date.
End date Allows you to specify whether the script has an end date.

IMPORTANT:

  • If start and/or end dates are specified, they are considered against the range of the period scenario, which must be fully included within the validity period of the script. If not specified, the script is always run.

Logical dimensions attributes tab

Element Description
Script operand code Code that identifies the script operand. Must not contain special characters. Follows the same rules as used for the application's code fields.
Logical dimension Logical dimension of the operand
Field code Field of the dataset associated with the logical dimension of the operand. IMPORTANT: the Script operand code/Logical dimension pair must be unique to the Analytical Workspace.