Create a Conversion Measure for Currencies

With a currency conversion measure, you can convert currencies into a target currency.

Prerequisites

To prepare for currency conversion, you must import the TCUR* tables to your space from your SAP system (or have these tables shared to your space from another space). See Enabling Currency Conversion with TCUR* Tables and Views.

Context

The sources of your analytic model may have values in different currencies. You can convert measures with currencies into a common target currency in SAP Datasphere to enable a proper data analysis.

Procedure

  1. You are in the editor of your analytic model. You can create a new currency conversion measure by clicking the background of the canvas and choosing Add Measure in the properties panel. Choose Conversion Measure.
  2. Edit the following properties:

    Property

    Description

    Business Name

    Enter a descriptive name to help users identify the object. This name can be changed at any time.

    Technical Name

    Displays the name used in scripts and code, synchronized by default with the Business Name.

    To override the default technical name, enter a new one in the field. Technical names can contain only alphanumeric characters and underscores.
  3. Select the source measure. The source measure has to be a fact source and has to refer to a measure in the underlying fact with semantic type Amount with Currency. The measure in the fact has to have an assigned currency field.
  4. Define the currency properties:

    Property

    Description

    Target Currency

    The target currency can be specified as:

    • a constant value

    • a reference to a dimension that is mapped to an attribute of the fact with semantic type Currency Code.

    • a variable. For more information, see Use Variables for Conversion.

    Reference Date

    The reference date can be:

    • the current date

    • a constant value, with a fixed date

    • a reference to a dimension with data type Date

    • a variable. For more information, see Use Variables for Conversion.

    Exchange Rate Type

    The exchange rate types are predefined.
  5. Define further properties:

    Property

    Description

    Client

    The conversion tables have a client field, which you can enter here.

    Error

    Select the error handling method. This defines how the system reacts when a value cannot be converted. Possible values are:

    • Set to null

    • Fail on error

    • Keep unconverted

    Formatting

    You can change the format of a measure in an analytic model. You can change the scale (Thousand, Million, Billion, Percent) and the number of decimal places.

    Settings

    Decide whether your measure should be an Auxiliary Measure. An auxiliary measure can be used for further calculation but it will be hidden in the story in SAP Analytics Cloud. You can control whether currency conversion applies a shift (for example JPY ×100) or not, so that both shifted and unshifted measures can correctly be processed without values being shifted twice.