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
- Open a model and switch to the Calculations Workspace.
- Select a Conversion Measure and see an "Add Missing Rates" hyperlink in the Calculations Preview panel similar to the following screenshot.
- Click Add Missing Rates to open the Currency Rates table used by the model.
- The Add Missing Rates preview dialog shows no missing rates.
Cause
It is possible that the structure priority on the model is set to Account instead of Measures.
Resolution
- Select the Structure Priority tab on Model Preferences within the model.
- Select Measures if the priority has been set to Account.
- Save the model.
- Switch to the Calculation Workspace and select the Conversion Measure.
- Choose Add Missing Rates to see missing rates are now seen in the Currency Rates Table > Add Missing Rates preview dialog.
Keywords
Currency Conversion, Currency Rates Table, Missing Currency, Structure Priority , KBA , LOD-ANA-ML-CAL , Calculation Management , LOD-ANA-ML , SAC Modelling , Problem