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.

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.

The Add Missing Rates panel 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, select Conversion Errors. 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.