Add Missing Rates in a Currency Table

As planning users work with model data in stories, they may try to analyze currency data that depends on rates that do not exist in the rate table.

Context

For example, if a user creates a Forecast version in a story that uses currency conversion, but the currency table only has rates that apply to the Actuals and Budget versions, the forecast data cannot be converted.

The way you add missing rates differs depending on whether your tenant is based on a Cloud Foundry or Neo environment:

On Neo tenants, you add missing rates using the right panel within the Modeler. There is no search functionality.
On Cloud Foundry tenants, you add missing rates using a dedicated dialog. There is also a search functionality to help you look for missing rates and add them quickly to the rate table.

When working with currency conversion in the Calculations space, the application lets you know in the calculation preview area if rates are missing in a given rate table. When that’s the case, an Add missing rates link is displayed to take you straight to the rate table. The same link is also displayed in stories. This link takes you to the Add Missing Rates panel on Neo tenants, or Add Missing Rates dialog on Cloud Foundry tenants.

The Add Missing Rates dialog helps you search for missing rates and add exchange rates quickly. Depending on the number of rates and currency combinations in the table, it can be useful to run a quick search to look for missing rates, especially if the rate table has a large number or rates.

For classic account models, any currency you add to a rate table applies to every measure in the table. The new model type however offers more flexibility, and allows you to select the base measure you would like to maintain. As a result, the Add Missing Rates panel can be slighty different depending on the model type you're working with.

Conversion Errors List

To view a list of conversion errors for every model that uses the currency table:

On Cloud Foundry tenants, select Conversion Errors in the workspace dropdown in the toolbar.
On Neo tenants, click the Conversion Errors tab.

The list shows a log entry for each time a currency conversion in a story has failed due to a missing rate in the currency table.

If the error occurred in a public version, you can select Analyze next to the error to add the rate using the  Add Missing Rates panel.

Note

In the current release, the Analyze function is not available for private versions.

Procedure

In the Add missing Rates panel, select a model that uses the rate table you want to update.
Select an optional Base Measure.
This helps in case you’re looking to update a rate for a given measure rather than for the whole model, and also limits the number of results returned when running a search. Note that this option is only available for the new model type, and isn't available for classic account models.
Note
Calculated measures and conversion measures aren’t supported.
Under Target Currency, if you want to manually add a fixed target currency, select Fixed and type the currency code. Or, if you want the target currency to be derived from a currency dimension, select From Dimension, and select the currency dimension.

Note
The From Dimension option is only supported by the new model type, and isn't available for classic account models.
Optional: Select a Category to look for missing rates in a specified category.
- To search for missing rates that apply to a particular rate version, click Specific Rate Version and select a Rate Version.
- If you’re looking for generic rates that don’t apply to a particular category, leave this field blank, and make sure Add category-dependent rates is unchecked.
- If you’re looking for missing rates that apply to category specific rates, leave the field blank, and make sure Add category-dependent rates is checked.
Specify how you’d like to run the search:
- Select Booking Date to find missing rates on the booking date only.
- Select Booking Date - 1 and then select a time period, to find missing rates during the time period preceding the booking date.
- Select Booking Date + 1 and then select a time period, to find missing rates during the time period following the booking date.
- Select Fixed Date and pick a date to find missing rates for a specific date.
Click Search.
The application displays a preview according to your search filters.
Note
If the application doesn’t return any results, reset or change the search filters, and run the search again.
Click Add to update the rate table with the new rates or Cancel if you don’t want to keep the new rates.
After you’ve added the new rates, the application automatically highlights them in the rate table.
In the toolbar, click Save to save the rate table.

Add Missing Rates in a Currency Table (Cloud Foundry)

Procedure

In the Modeler, open a currency conversion table.
Click  in the Edit section of the toolbar to open the dropdown menu and select Add Missing Rates.
In the Add Missing Rates dialog, select a source model that uses the rate table you want to update using the dedicated field.
Optional: If needed, specify a base measure.
Adding a base measure helps if you’re looking to update a rate for a given measure rather than for the whole model, and also limits the number of results returned when running a search. Note that this option is only available for the new model type and isn't available for classic account models.
Note
Only base measures with currency enabled are available in the dropdown menu.
Under Target Currency, if you want to manually add a fixed target currency, select Fixed and type the currency code. Or, if you want the target currency to be derived from a currency dimension, select From Dimension, and select the currency dimension.
Restriction
The From Dimension option is only supported by the new model type, and isn't available for classic account models.
Specify how you’d like to run the search:
- Select Booking Date to find missing rates on the booking date only.
- Select Booking Date - 1 and then select a time period, to find missing rates during the time period preceding the booking date.
- Select Booking Date + 1 and then select a time period, to find missing rates during the time period following the booking date.
- Select Fixed Date and pick a date to find missing rates for a specific date.
Optional: If needed, select a category to look for missing rates in a specified category.
1. To search for missing rates that apply to a particular rate version, click Specific Rate Version and select a Rate Version.
2. If you’re looking for generic rates that don’t apply to a particular category, select Rate Without Category.
Click Next to get a preview of the results.
If the application doesn’t return any results, reset, or change the search filters, and run the search again.
Click Add to add missing rates to the table, or Back to refine the search.

Results

Back in the grid view, the rates you have added are highlighted in yellow.