SAP Analytics Cloud Currency Conversion with DSP

[#1]

SAC Currency Translation Using Datasphere Exchange Rate Table Gives Result Divided by 10 Compared to SAC Rate Model

Hi Experts,

We are experiencing inconsistent currency translation results in SAP Analytics Cloud when using a Datasphere-based exchange rate table.

Scenario

Source Amount:

• Currency: OMR
• Amount: -2,000,000

Exchange Rate (AF04):

• OMR ->AED
• Rate: 9.55274

Expected Result:

-2,000,000 * 9.55274

= -19,105,480

Actual Result using Datasphere Rate Table:

-1,910,548

The result appears to be shifted by exactly one decimal place (÷10).

Check performed

1. Same conversion works correctly when using the native SAC Rate Model.
2. Exchange rate value in Datasphere is DECIMAL(17,5).
3. FFACT = 1 and TFACT = 1.
4. OMR is maintained with 3 decimals in TCURX.
5. Exchange rate is extracted directly from TCURR: