3765050 - SAC Data Action fails with "Missing currency conversions from '' to <currency>" during currency conversion step

• Data action fails during currency conversion step with the error: "Missing currency conversions from '' to '<FixedCurrency>' on 'dd.mm.yyyy' in rate table 'XYZ'."
• Error message shows an empty source currency ("").
• Exchange rates are maintained in the rate table.
• There is no missing currency rate to add.

• Product: SAP Analytics Cloud
• Data Actions

1. Run a data action includes the step to convert source currency to a target currency for a given date.
2. Observe that the step fails and the job log shows MISSING_CURRENCY_CONVERSION_RATES with: "Missing currency conversions from '' to '<Currency>' on '' in rate table 'XYZ'."

Certain dimension members (with currency enabled) used by the data action have no currency assigned.

Because fact data exist for these members, the conversion engine attempts to convert the value but cannot determine a source currency, resulting in an empty source currency ("") in the error.

1. Identify the dimension that provides the source currency for conversion.
2. Open the dimension in the modeler and review the currency attribute for all members included in the data action’s filters, prompts, or selection scope.
3. Assign a valid currency to any members that currently have no currency but have posted fact data.
4. Verify that the rate table contains rates for the maintained source currencies to the target currency for the relevant date, type, category, and version.
5. Save changes to the dimension and refresh the model if required.
6. Rerun the data action or multi action and confirm the conversion completes without the "Missing currency conversions from '' ..." error.

• refer to: SAC currency conversion: add missing rates – but they are not missing
• refer to: SAP analytics cloud planning – converting data
• refer to: Currency exchange rates

sac, data action, multi action, currency conversion, missing currency conversions, MISSING_CURRENCY_CONVERSION_RATES, empty source currency, blank currency, rate table, exchange rates, dimension currency, wbs element, planning model, job log error, target currency , KBA , LOD-ANA-PL-DA , Data Actions , LOD-ANA-ML-CAL , Calculation Management , Problem