SAP Knowledge Base Article - Public

3377475 - Currency Measures May Not Import Successfully via BW Live Model in SAP Analytics Cloud (SAC)


  • Measure value "0.0" does not import with any currency metadata for Live BW Models in SAP Analytics Cloud.
  • This may result in currency formatting, calculation, and conversion issues.


  • 2023.16.4

Reproducing the Issue

  1. Import currency data from BW Live Model into an SAP Analytics Clous (SAC) Table.
  2. Enable currency formatting symbols along an arbitrary given axis.
  3. Notice currency labels display "##" instead of "$" as an example.
    • This indicates currency metadata is importing unsuccessfully.


  • SAP BW Query Key Figure contains a formula with conditions (IF/ELSE) returning zero as value with no associated Key Figure.

  • Since there is no associated key figure, there will not have associated currency/unit. 
    For a similar situation, see the SAP Note:

    2298745 - 0 with mixed currency or unit as result of multiplication or division


  • Update the SAP BW Query Formula to have an associated Key Figure when there is a zero. The formula will look like:

    IF <CONDITION> THEN <Key Figure> ELSE 0 * <Key Figure>


See Also


BW live, model, currency, formatting, currency symbol , KBA , LOD-ANA-DES , Story Design & Visualizations , LOD-ANA-AQU-BW , Data Acquisition from BW , Problem


SAP Analytics Cloud 1.0