Calculation logics of 'Multi-Dimensional Script' type

Calculation logics of "Multi-Dimensional Script" type

A Multi-dimensional calculation logic is a sophisticated script written using the TGKML Tagetik syntax derived from the MultiDimensional eXpressions (MDX) language for the OLAP analysis on SQL Server. As the MDX technology does, the TGKML scripts reads and write data applying the concept of "cube". A cube is a multi-dimensional representation of data. Each cube is defined by a set of dimensions which, in some cases, can be the same for different cubes.

With a single script the user can define several calculations which are processed by the system in the order they are in the script. The result of the script is saved into the Tagetik data tables.

It is possible to set the synchronization level of Delete and Insert when running Multidimensional Script formulas in order to optimise the performance

The synchronization level must be set up in the general settings (Setup & Admin > Data Model > Dimensions > Settings) (Navbar > Dimensions > Settings) by opportunely setting the MD engine synchronization level option available in the Advanced section.

For further details, please see the BasicAdmin manual in Configuration section.