Symptom
An Add Missing Rates message appears in your model, even though the Dynamic Category is set.
Environment
SAP Analytics Cloud 2022.21 and higher
Reproducing the Issue
- In the modeler, a currency conversion measure is configured using the Dynamic category setting.
- An error similar to the following is seen in the Calculation Preview panel:
Cause
Choosing the Dynamic setting indicates that generic rates will be used with no category setting. However, generic rates are not applied to the Specific category with a Rate Version.
Resolution
Specific versions and calculations will only use rates from that rate version, therefore, missing rates must be added to the version as it will not default to use generic rates.
See Also
Keywords
Currency Conversion, Currency Rates Table, Specific Category, Dynamic Category, Add Missing Rates , KBA , LOD-ANA-ML-CAL , Calculation Management , LOD-ANA-ML , SAC Modelling , Problem