SAP Knowledge Base Article - Public

3342363 - Add Missing Rates Shows No Missing Currency Results

Symptom

"Add Missing Rates" is seen in a SAP Analytics Cloud model but does not display any missing currency rates when selected.

Environment

SAP Analytics Cloud 2023 and higher

Note: Screenshots reflect UI for Cloud Foundry tenants from QRC 3 2023, however, this is also recreatable for NEO tenants and on previous releases.

Reproducing the Issue

  1. Open a model and switch to the Calculations Workspace.
  2. Select a Conversion Measure and see an "Add Missing Rates" hyperlink in the Calculations Preview panel similar to the following screenshot.
  3.  AddMissingRates.png
  4. Click Add Missing Rates to open the Currency Rates table used by the model.
  5. The Add Missing Rates preview dialog shows no missing rates.

AddMissingRatesNoResults.png                                                                                                                                                                                                                                    

Cause

It is possible that the structure priority on the model is set to Account instead of Measures.

Resolution

  1. Select the Structure Priority tab on Model Preferences within the model.
  2. Select Measures if the priority has been set to Account.                                                                                                                                                                                                                                                                                   
  3.  StructurePriority.png
  4. Save the model.
  5. Switch to the Calculation Workspace and select the Conversion Measure.
  6. Choose Add Missing Rates to see missing rates are now seen in the Currency Rates Table > Add Missing Rates preview dialog.                                                                                                                                                                               
  7.  AddMissingRatesMeasure.png

Keywords

Currency Conversion, Currency Rates Table, Missing Currency, Structure Priority , KBA , LOD-ANA-ML-CAL , Calculation Management , LOD-ANA-ML , SAC Modelling , Problem

Product

SAP Analytics Cloud all versions