3731194 - Currency conversion uses blank rate type for balance sheet accounts and shows missing rates errors

• Currency conversion for balance sheet accounts is not functioning as expected.
• The system applies a rate with a blank Rate Type instead of the expected Average (for P&L) or Closing (for balance sheet) rate based on account settings.
• Error: "The currency conversion failed. Please provide missing rates for all needed rate types and categories in the rate table 'sap.epm:Currency_Rates'."
• Error: "Could not convert from '' to '' on ''. Please provide missing rates for all needed types, categories and versions in the rate table."

• SAP Analytics Cloud

1. Open a story with a table that displays measures requiring currency conversion.
2. Filter to a scope with booked balance sheet .
3. Launch the data action that performs currency conversion .
4. Observe that conversion succeeds only when a blank Rate Type exists in the currency table, and errors appear when that entry is removed.

• The model Structure Priority is set to Measure, so the currency conversion derives the Rate Type from the source measure instead of the Account dimension.
• The source measure has an empty Rate Type, resulting in the system using a blank Rate Type from the currency table.
• In addition, if the conversion scope includes accounts without a Rate Type maintained, a blank Rate Type entry is required; otherwise, “missing rates” errors occur.

Decide how Rate Type should be derived:

1. If you want to use Account-based rate types (Average/Closing): set the model Structure Priority to Account so conversion derives Rate Type from the Account dimension.

2. If you keep Structure Priority = Measure: maintain the Rate Type on each relevant base measure . If needed, create separate measures to represent different rate types.

Ensure all involved accounts have an appropriate Rate Type maintained in the Account dimension to avoid reliance on a blank Rate Type.

Maintain required exchange rates in the currency table for all used Rate Types and categories/versions. If any account without a Rate Type remains in the conversion scope, either assign a Rate Type to that account or maintain a blank Rate Type entry as a temporary fallback.

Narrow the data action scope (for example, add an account filter) to identify accounts lacking Rate Type settings that cause “missing rates” errors, then correct those accounts or the rates.

Re-run the data action and confirm conversion uses the intended Rate Type and completes without missing rates notifications.

• Refer to: Work with Currencies in a Standard Model
• Refer to: Displaying Currencies in Tables
• Refer to: 2632276 - The currency conversion failed. Please provide missing rates for all needed rate types and categories in the rate table {0}
• Refer to: 2482105 - Currency conversion failed error: provide missing rates for all needed types, categories and versions

currency conversion, balance sheet accounts, rate type, average rate, closing rate, structure priority, measure priority, account priority, base measure rate type, currency table, sap.epm:Currency_Rates, missing rates, blank rate type, data action, sac model , KBA , LOD-ANA-PL-DA , Data Actions , Problem