Currency

The Currency section lets you set the currency and currency conversion settings on your model.

For information about different currency scenarios, see Selecting the Right Model for Your Data.

Currency Settings Without Conversion

If your model doesn't use currency conversion, set one of the following options:

  • Default Currency: The currency for all monetary values. For example, if your model only contains monetary values in US Dollars, you can set the default currency to USD.
  • Currency Dimension: The dimension that separates model data into different currencies. Model data will not be aggregated across the different currencies. For more information about adding a Currency column to a dimension, see Learn About Dimensions and Measures.

Currency Settings with Conversion

Enabling currency conversion allows model data from different source currencies to be converted into a single target currency and then aggregated.

To enable currency conversion, activate the Currency Conversion switch. Then, specify the following settings:

Default Currency: Type the three-character code for the default currency. Monetary data will be converted to this currency by default.

Currency Dimension: Select the dimension that separates model data into different currencies. For more information about adding a Currency column to a dimension, see Learn About Dimensions and Measures.

Currency Rates Table: Select a currency conversion table. The drop-down list shows all tables that have already been created on the Currency Conversion tab of the Modeler.

Preconverted Actuals: When this setting is on, both source currency data and preconverted currency data can be imported. For more information, see Learn About Preconverted Currency Data.

Maximum number of Currency Conversions: This setting determines how many different currency conversions can be simultaneously displayed in a table based on this model. For example, if you want to enable users to view side-by-side figures for USD at the Budget rate, USD at the Forecast rate, and USD at rates defined for three different fixed dates, you can set the limit to five.

Note
  • You can increase this limit after creating the model, but it cannot be decreased.
  • When you increase the limit after creating the model, the new limit does not apply to existing stories. Each story keeps the limit that was valid when the story was created.
  • Displaying data in its source currency does not count towards the Maximum Currency Conversion Limit.
  • If the model uses currency conversion, each Account member has to have Currency set for the Units & Currencies attribute (column) of the Account dimension.

Currency Conversion Settings with Currency Variables

In a model with measures, you can use a currency variable to drive conversion measures bound to that variable and switch target currencies on the fly to update calculations both within the Modeler, via the Calculations workspace, and in stories via the filter bar or story and widget prompts.

To set up a currency variable, currency conversion must be turned on. Click Create Currency Variable, and specify the following settings:
  • Variable ID: That setting is automatically pre-filled.
  • Variable Description: Add a description for the currency variable.
  • Default Value: Select a default target currency in the dedicated drop-down. The target currencies available are derived from the currency rate table you’ve selected when enabling currency conversion. If needed, you can also decide to apply no conversion and stick to the source currency of the base measure by selecting No Conversion.

    For more information, see Work with Currencies in a Model with Measures.