Currency and Currency Translation in Lucanet xP&A

Currency settings and currency translation in Lucanet xP&A (Extended Planning & Analysis) allow you to flexibly set up your planning in multiple currencies.

As a first step, currency translation in Lucanet xP&A must be set at organization level.

If you wish to use different currency translation behaviors in Lucanet xP&A at model, variable, or dimension level, you can adjust the settings for these levels individually.

As a first step for automatically translating currencies between different variables and data sources in xP&A, you have to set the currency for your organization. Proceed as follows:

By default, each new model in Lucanet xP&A will use the currency translation settings configured at organization level.

If you want to use different currency translation behavior in a model, you can adjust it in the model settings. These model-level settings determine how the model interprets and translates values throughout all variables (unless you configure individual translation behavior at variable level.)

By default, a variable in Lucanet xP&A uses the same default currency and currency translation settings as the model it is used in.

However, you can change the currency settings for each variable, e.g., to set a variable to USD even if the model is EUR.

To individually set the currency of a variable:

For variables with dimensions (e.g., Region, Entity, Country) in Lucanet xP&A, different currencies can be assigned per dimension item.

Example:

Totals always use values converted into the variable’s currency before aggregating.

You can set a default currency for each dimension item in the Dimension Settings. This saves time when you have many variables using the same dimension item, as the variables by default use this currency then.

If needed, you can also specify individually for each variable, if the dimension items used therein use a different currency.

By default, a model in Lucanet xP&A displays all currencies in the local currency that has been configured for them.

You can change this setting so that the variables and dimensions are displayed in another display currency, converting all the currencies based on the configured exchange rates.

To do so, open the currency options in the top ribbon of a model and choose, if you want to display the local currency or any other currency for which an exchange rate has been defined:

You can set a currency for every data source used to integrate data into Lucanet xP&A from a source system.

General Behavior

When connected data that has a currency set is connected to a variable in a different currency, xP&A will automatically convert all values pulled in from a data source to the currency set for the variable:

Behavior With Multiple Data Sources

If more than one data source is connected to the same variable, all data sources are automatically converted into one target currency.

By default, the first added data source’s currency becomes the initial target currency.

You can override this behavior in the variable’s currency settings. All other data sources connected to this variable will be converted into that variable's target currency.

This section answers frequently asked questions about currency translation in Lucanet xP&A.

There are many ways you can set up your consolidation in Lucanet xP&A.

You can either have no entity breakdown (in which case you would drill-down to see detail at the entity level), or you can use dimensions to break down by entity (see below) which means you can easily visualise historics by entity, and forecast by entity, too.

To set up entity-level breakdown in Lucanet xP&A: