3697890 - Currency Conversion Data Action Issue

Data action execution fails with a “missing currency conversion rate” error in public edit versions when dynamic rate selection is used, even though the exchange rates exist in the rate table.

SAP ANALYTICS CLOUD

1. Run the data action
2. the error pops up: missing currency conversion rate from "" to '' on "" in rate table ''.To run step 1 ("currency conversion") of data action on version '' please provide missing rates for all needed types,categories and versions in the rate table.

When a public edit version is created, it keeps the currency rate version that was valid at the time of creation.
If the model’s rate version is later updated, the public edit version continues to reference the old rate version.

During data action execution with dynamic rate selection, the system reads the rate version from the public edit version.
As a result, the data action may try to use an outdated rate version that no longer contains the required exchange rates, leading to the error.

This behavior is by design in SAP Analytics Cloud.

• Publish or revert existing public edit versions that reference outdated rate versions.
• Create a new public edit version, which will automatically use the current rate version from the model.
• Re-run the data action using dynamic rate selection.

data action, missing rates,currency conversion,sac,publish,version. , KBA , LOD-ANA-PL-DA , Data Actions , Problem