Skip to content

Currency conversion

Introduction

Currency conversion on the multidimensional matrix can be performed in SmartInsight in two ways: from the Filters panel or from the matrix itself (see The structure of the matrix). Some particular cases which may arise depending on the type of dataset used in the matrix are outlined below.

Conversion on financial matrix

For multidimensional matrices defined on the financial dataset, the following elements can also be customised: FX rate type, Reference Scenario and Reference Period.

The following FX rate types are supported:

  • final FX rate
  • average FX rate
  • period average FX rate
  • account-based FX rate

Conversion on analytical matrix

For multidimensional matrices defined on the analytic dataset, it is only possible to apply the conversion on the fly if the currency dimension is present in the dataset.

The following FX rate types are supported:

  • measure-based FX rate
  • account-based FX rate, only if the reference analytic dataset contains the account dimension.