SAP Knowledge Base Article - Public

3519420 - SAP Analytics Cloud: Displaying Symbol before value is not possible when defining symbol in Formatting tab

Symptom

  • In SAP Analytics Cloud, it is possible to change the currency symbol in a table to match the profile settings of the user if the currency symbol is generated by SAC based on model and dimension properties.
  • In this way the currency symbol can be changed to show either before or after the value in the cell.
  • However, if a symbol is added manually in the "Unit" field in the formatting tab of a table this symbol will always display after the cell and not take into account the user profile settings.

Environment

SAP Analytics Cloud, SAP Data Warehouse Cloud, SAC Story Calculations

Reproducing the Issue

Enable show scale and unit values in cells from the table styling panel.

Enable formatting of a calculated KPI and set the show unit as $ or any other symbol.

Observe that the $ sign is displayed after the cell regardless of users profile settings.

Cause

Resolution

  1. Formatting is based on various settings applied in the following order: Widget Settings > Calculation Settings > Profile Settings > Tenant Configuration.
  2. Changes made in Profile settings will apply for default measures only. Calculations will not respect these if the format settings are changed at the calculation level.
  3. The currency position changed in profile settings will apply only for the currency symbols. In calculations, units are used which can be of any string type (not only the currency symbols). Hence, the currency settings cannot be applied to unit type in calculations.
  4. If the "Use unit of underlying measures" option in calculation format settings is enabled and the unit is provided as $, then the calculation data will display the provided symbol at the end of the value only.
  5. To retain the currency position, enable the "Use unit of underlying measures" option with currency type declared at model level.

See Also

Keywords

SAP Analytics Cloud, SAP Data Warehouse Cloud, KPI values, currency symbol, prefix, suffix, profile settings, calculation settings, unit of underlying measures, currency position , KBA , LOD-ANA-DES-CAL , SAC Story Calculations , LOD-ANA-UNS-DSG , Unified Story Designer Issues , LOD-ANA-TAB , Table , How To

Product

SAP Analytics Cloud all versions