Debug MD calculation logics

Tagetik allows the user to run in debug mode a calculation logic of "Multi-dimensional script" type. This feature allows to run a TGKML script both on original scenarios and on the consolidation scenarios, and then to analyze the script run steps by a graphical display in order to check the partial results and to analyze the performance of the various steps.

To run a TGKML script in debug mode, it is necessary to open the calculation logics elements table and, after selecting the "Multi-Dimensional Script" logic to run, click on the icon below the magnifier.

The system opens the Debug MD calculation logics window ; the selected MD appears on the right of the window, while on the left side it is necessary to select the run filters:

  • the process on which the script must be run;
  • the scenario / period on which the script must be run.

  • the list of entities to run; if the field is left empty, all entities will be run

  • a set of filters to limit the elements of the various dimensions on which the script must be run:

  • Data type - Amounts: gross data and IC entries are run
  • Data type - Journals: entity and consolidation journals are run
  • Categories: filters the data to run on the basis of the categories;
  • Journal number: filters the journals to run according to the selection;
  • Custom dimension 1...5: filters the data to run on the basis of the elements of the custom dimension 1...5.

The script is run only for those entities for which at least a not submitted step exists: therefore, if the selected list contains elements for which all steps are submitted, the data processing won't be run on such elements

When clicking on "Debug", the selected scrip will be run applying the set up filters.

By hovering over the button, the "Debug without details" item appears. With this item it is possible to run the debug without the execution details.

After running the script, the system opens a window showing the execution steps in the form of graph.

The tree structure describing the execution of the script is displayed on the left of the window. The root of this tree is represented by the calculation logic. Each node of the tree can relate to the account to calculate, to an input account, to an arithmetical operator or a numerical coefficient.

  • The “Final operations” node is not a debug node but a node which allows monitoring the loading operation period and then evaluate the performance of the calculation logic;
  • If the TGKML syntax of the calculation logic provides for a multicube assignment, several nodes with the same structure, one for each cube, will be created in the tree

By clicking on the node, it is possible to display on the bottom of the panel the arithmetical Expression evaluated in relation to that node.

On the nodes related to the input accounts and arithmetical operators (in bold), it is possible to display on the right of the window the partial results related to the selected input account / arithmetical operator.