Skip to content

Tagetik Models

A Tagetik Model corresponds to a Microsoft SQL Server Analysis Services (SSAS) Model which is created and managed through the admin interface of CCH Tagetik.

The Tagetik models configuration page can be accessed via the "Analytics" tile in the Home page - AdministratorHomepage.

A model is actually created as a SSAS model as soon as the first deploy is run.

When a deployed model is removed from CCH Tagetik, it will be removed from the SSAS database as well.

Each model is identified by a Code and a Description and is characterized by a set of attributes defining how the SSAS model has to be generated.

Attributes

The Attributes panel contains the generic parameters that define the model:

  • Code. ID code of the model.
  • Description. Description of the model.
  • Name of the SSAS Database that corresponds to this model
  • Cube. Name of the cube for this SSAS model
  • Service Analysis Services. This is the TGK Service resource to be used for deploying the model. The TGK Service is set up in the Repository.

The following details have to be specified in the "Advanced settings" area of the panel:

  • Language. Language of the description of the dimensions' elements.
  • Template. Specifies if the model must be based on the CCH Tagetik standard template or on a custom template (from Analysis Services): in this case, it is necessary to specify the Template's name, namely the name of the SSAS database for the creation of the model.
  • Users definition. When the standard template is used (see above), it is possible to see a list of the domain users who can access the cube. The user must be shown as domain@user; to allow all users to navigate the cube, it is possible to add “everyone”, namely the keyword of the active directory meaning "all users". This option is not available when a template from Analysis Services is in use: in this case, the user access can be set up directly inside the template.
  • "Disable Optimize sum formulas in Financial Statement Templates".

This option indicates the calculation method of the formula FST items whose formula is a sum of elements of account type.

If this option is disabled, such items are calculated as aggregations of elements of account type (typically, this calculation has a better performance).

If this option is enabled, such items are calculated via MDX script of SSAS cube.

The management of the time dimension in the SSAS cube can be set up in the "Cube type" area.

  • Time – Version. With the Time – Version cube, the management of the time dimension is based on a calendar dimension based on the "End date" defined inside the periods of CCH Tagetik and on the "Version" defined on the Scenario of CCH Tagetik.
  • Scenario - Period. The time dimension is managed through the Scenario and Period dimensions set up in CCH Tagetik. The cube contains also the "Reference Scenario" and "Period length" dimensions.

  • Aggregation over time for Stocks and BS accounts. This is enabled only if the selected cube is Time – Version type and determines the aggregation type on the Stocks and BS accounts. This can get the following values:

  • First Last period. The values taken into account are those of the first and of the last selected periods (even though they are not filled in).

  • Defined First Last period – Null values filled in with 0 on the periods opened in Tagetik. The values taken into account are those of the fist and of the last periods that are not empty (by filling the null values with a zero for all the periods opened in Tagetik)

  • Partitions advanced management. Selecting it enables the advanced management of the partitions. The user can define the partitions by setting the filters on the scenario and the data types (original, consolidated and offline) that will populate the cube. When this is selected, it is no longer possible to insert the filter on the Scenarios grouping as they will be specified in each partition.

  • Scenarios Grouping. This is enabled only if the Partitions Advanced Management is not enabled (see above). It determines which scenarios grouping contained in the Tagetik list will populate the time dimensions and the subset of data. Only grouping's nodes that do not contain multiple relationships can be chosen.

  • Category grouping. Categories grouping contained in the Tagetik's List that will populate the categories dimensions and the sub-set of data.

The Attributes panel shows some additional information on the model:

  • Last change. Date of the last modification to the model.

  • User. User who made the last modifications to the model.

  • Last Deploy. Date of the last deploy of the model.

Partitions advanced management panel

This panel is available only if the "Partition Advanced management" option has been enabled in the "Attributes" panel when saving the model.

You can add further partitions according to the version of SSAS in use: with the Standard Edition you can create up to 3 partitions, whereas with the Enterprise edition you can create as many partitions as you like. For each partition, it is necessary to specify a code, a description, a filter on the scenarios groupings and the type of data to be inserted, by selecting the following flags:

  • Original Open. Original open data will be inserted in the partition.
  • Original Closed. Original closed data will be inserted in the partition.
  • Original Archive. Original offline data will be inserted in the partition.
  • Consolidated Open and Closed. Consolidated, open and closed data, both amounts and adjustments, will be inserted in the partition.
  • Consolidated Archive. Consolidated offline data, both amounts and adjustments, will be inserted in the partition.
  • Open Original data adjustments. Adjustments' open original data will be inserted in the partition.
  • Closed Original data adjustments. Adjustments' closed original data will be inserted in the partition.
  • Archive Original data adjustments. Adjustments' offline original data will be inserted in the partition.

A specific check will prevent data from being duplicated inside the cube, therefore it is not possible to insert the same type of data for the same scenario in different partitions.

Calculations and Measures panel

In this panel you can set up the dimensions for the calculations (e.g. for the On-the-fly Conversion) and the measures you want to be included in the model, as well as their name.

It is also possible to insert a MDX script that will be added to the MDX script of the SSAS cube: the script must be written with the syntax requested by SSAS, by following the names given to the various dimensions and measures of the model.

Conversion Panel

In the Conversion Panel you can set up some dimensions for the currency conversion of data.

The settings contained in the panel vary depending on the "Cube type" displayed in the "Attributes" panel.

A "Time Version" model contains the following dimensions:

  • The "Conversion" dimension that specifies the currency to which the amounts have to be converted
  • The dimensions for the "Conversion at specific FX rate", namely "Reference currency", "Reference time" and "Reference version".

Only the "Conversion" dimension is used in the cube to convert the analysed data to another currency.

The "Reference Currency", "Reference Time" and "Reference Version" dimensions are used in the cube to convert the analysed data to another currency but at a FX rate that refers to a specific moment in time.

A "Scenario Period" Database contains the following dimensions:

  • The "Conversion" dimension that specifies the currency to which the amounts have to be converted
  • The dimensions for the "Conversion at specific FX rate", namely "Reference Scenario" and "Reference Period"

Only the "Conversion" dimension has to be used in the cube to convert the analysed data to another currency.

The "Conversion", "Reference Scenario" and "Reference period" dimensions are used in the cube to convert the analysed data to another currency but at a FX rate that refers to a specific moment in time.

To convert the analysed data to the data's currency at a FX rate that refers to a specific moment in time , it is necessary to use only the "Reference Scenario" and "Reference Period" dimensions and not the "Conversion" dimension.

Dimensions panel

In the remaining panels you can set up the dimensions you want to be included in the model, as well as the hierarchies, their names and other specific attributes for each dimension.

Deploy Action

The deploy data processing creates the model on the SSAS server when it is run for the first time for a given Tagetik model. It updates the SSAS model when it is launched following the modification of the Tagetik model.

Any modification made in the Tagetik models administration page won't affect the SSAS model until the execution of the deploy data processing.

Process Action

The process data processing of a model updates the SSAS cube of that specific model.

It can be run only after at least one execution of the deploy data processing.

If the "Only partitions" option is selected, only the values in the cube are updated but not the dimensions. This reduces the process time but it is achievable only if no changes have occurred in the dimensions contained in the cube since the last time the process data processing has been run.

If the model has the "Partitions Advanced Management" option enabled in the "Attributes" panel, the process data processing can be run also for just one or a specific set of partitions.

Download MDXScript Action

The model process data processing, besides updating the cube's data, creates the corresponding MDX script. Through the "Download MDXScript" action it is possible to download to a text file the MDX script of the cube generated by the process data processing, for example for test purposes or for the development of custom MDX calculations to be added to the cube through the "Customized Script MDX" field available in the "Calculations and Measures" panel.