Skip to content

Cubes and dimensions

Each cube is identified by an acronym written between brackets and has a different meaning according as it is in the "input" or in the "output" part of the TGKML script. If it is:

  • in the "input" part (input cube), it represents the "virtual" data table used to retrieve data from the database. Technically data are read from a view which puts together the records of one or several tables
  • in the "output" part (output cube), it represents the physical tables in which the system saves the script's result. In a TGKML script only one output cube can be defined.

Dimensions

The Tagetik dimensions on which the cubes are based and which can be referred into the script are listed below:

  • the scenario/period time dimension (Time (Scenario,Period));
  • the scenario (Scenario);
  • the period (Period);
  • the entity(Entity);
  • the Ctp entity(EntityCtp);
  • the Ctp custom dimension 2(Dest2Ctp);
  • the category (Category);
  • the custom dimensions (DestN);
  • the journal number (NumRett);
  • the Ctp entity for segment (AziCtpSegment);
  • the Ctp custom dimension 2 for segment(Dest2CtpSegment);
  • the currency (Currency);
  • the currency 2 (Currency2).

Cubes

The cubes which can be managed in a script are listed below:

  • Cubes on original scenarios.
  • [LO]. It represents the gross amounts plus the journals. The dimensions of these cube are:Time (Scenario, Period), Entity, Category, Dest1, Dest2, Dest3, Dest4, Dest5, Currency.
  • Data are read from the database view V_DATI_LORDI_RETT_RIGA which is the combination of the gross amounts tables (DATI_SALDI_LORDI) and the journals (DATI_RETT_RIGA) on child categories of the amount categories with not valued counterparty)
  • Data are written on the gross amounts table (DATI_SALDI_LORDI)
  • [IC]. I represents the intercompany amounts plus the journals. The dimensions of this cube are:Time (Scenario, Period), Entity, Category, Dest1, Dest2, Dest3, Dest4, Dest5, Currency, EntityCtp, Dest2Ctp.
  • Data are read form the database view V_DATI_IC_RETT_RIGA which is the combination of the IC amounts tables (DATI_SALDI_IC) and the adjustments (DATI_RETT_RIGA) on child categories of the amount categories with valued counterparty
  • Data are written into the IC amounts table (DATI_SALDI_IC)
  • [RETT]. Represents the entity and consolidation journals. The dimensions of this cube are: Time (Scenario, Period), NumRett, Entity, Category, Dest1, Dest2, Dest3, Dest4, Dest5, Currency, EntityCtp, Dest2Ctp, AziCtpSegment, Dest2CtpSegment.
  • Data are read and written from / into the DATI_RETT_RIGA table
  • [SA]. It represent the amounts in general. The dimensions of this cube are the same of the [IC] one but the counterparty dimension can be null:Time (Scenario, Period), Entity, Category, Dest1, Dest2, Dest3, Dest4, Dest5, Currency, EntityCtp, Dest2Ctp.
  • Read Data(gross and intercompany) are the combination of the [IC] and [LO] cubes and generates two sets: intercompany data (with counterparty) and the minorities quota (calculated by subtracting IC data from gross data)

  • Data with counterparty are written into the DATI_SALDI_IC table while the gross amounts (calculated by summing up the minorities and the intercompany) are written into the DATI_SALDI_LORDI table.

  • Cubes on consolidation scenarios

  • [SA_C]. It represents the consolidable amounts. The dimensions of this cube are: Time (Scenario, Period), Entity, Category, Dest1, Dest2, Dest3, Dest4, Dest5, Currency, EntityCtp, Dest2Ctp.

  • Data are read / written from / into the DATI_SALDI_CONS table

  • [RETT_C]. It represents the consolidable journals the consolidable amount type. The dimensions of this cube are: Time (Scenario, Period), NumRett, Entity, Category, Dest1, Dest2, Dest3, Dest4, Dest5, Currency, EntityCtp, Dest2Ctp, AziCtpSegment, Dest2CtpSegment.

  • Data are read / written from / into the DATI_RETT_RIGA_CONS table

  • [SA_RETT_C]. It represents the amounts and consolidable journals. The dimensions of this cube are:Time (Scenario, Period), Entity, Category, Dest1, Dest2, Dest3, Dest4, Dest5, Currency, EntityCtp, Dest2Ctp.

  • Data are read from the DATI_SALDI_CONS e DATI_RETT_RIGA_CONS tables
  • Data are written into the amounts table (DATI_SALDI_CONS)