Amounts and currencies

Usually in the Tagetik data tables there are two different currencies and two amounts. All the available cubes use only one currency. The currency used for each data table is shown below:

• DATI_SALDI_LORDI: original currency
• DATI_SALDI_IC: Invoice currency
• DATI_RETT_RIGA: currency 2
• DATI_SALDI_CONS: currency
• DATI_RETT_RIGA_CONS: currency

When data are saved to the database, the system calculates "on the fly" the currency that is not used as dimension (thus that is not read from the input tables) in the cube according to the following rules:

• DATI_SALDI_LORDI, DATI_SALDI_IC: Entity Currency in the process
• DATI_RETT_RIGA: Journal currency
• DATI_SALDI_CONS, DATI_RETT_RIGA_CONS: Consolidation scenario currency.

Even though only one currency can be used as dimension in a cube the system, during the calculation step, uses both the amounts in the data tables. These amounts are:

• DATI_SALDI_LORDI.
• Amount 1: original currency amount
• Amount 2: Amount
• DATI_SALDI_IC.
• Amount1: invoice currency amount
• Amount 2: Amount
• DATI_RETT_RIGA.
• Amount 1: Amount 2
• Amount 2: Amount
• DATI_SALDI_CONS.
• Amount 1: Amount
• Amount 2: invoice currency amount
• DATI_RETT_RIGA_CONS.
• Amount 1: Amount
• Amount 2: Amount 2

The system calculates in parallel both the amounts. The only case when the system uses one amount only (amount 1) is in presence of a Boolean condition in the IF statement.