SAP Knowledge Base Article - Public

3243772 - Missing Rates for Currency Conversion Measure Using Dynamic Category

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

  1. In the modeler, a currency conversion measure is configured using the Dynamic category setting.
  2. An error similar to the following is seen in the Calculation Preview panel:

DynamicCategory.png

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.

SpecificCategory.png

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

Learn About Currency Conversion Tables

Adding a Currency Conversion Measure

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

Product

SAP Analytics Cloud all versions