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.

• SAP Analytics Cloud 2023.16.4

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>

   

• Displaying Currencies in Tables
• Currency Conversion (Specifics for SAP BW)
• BW Currency translation type
• FX Rates & Currency Exchange in SAP BW

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