SAP Knowledge Base Article - Public

3564957 - Double Hashtag "##" Display for Multiple Currencies in SAP Analytics Cloud

Symptom

  • When using an optimized story based on a Live Data, SAP Analytics Cloud (SAC) displays '##' instead of '*' when multiple currencies need to be displayed.
  • The issue is observed when no value is entered for the Target Currency prompt and the query is executed.

Environment

SAP Analytics Cloud Version: 2024.21.14

Reproducing the Issue

  1. Open SAP Analytics Cloud.

  2. Go to Story Tab > Open the Story based on the Live Data Connection.

  3. Observe the '##' displayed on the header of the column table.

Cause

SAP Analytics Cloud changes the multiple currencies to '##'.

Resolution

SAP Analytics Cloud uses the '##' if the backend is sending two different units for the cells on the same column. This is why '##' is seen in the headers and units in the cell.

This is the current display method and is by design on the product.

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

SAP Analytics Cloud, SAC, SAP, Analytics, Cloud, kba, note, help, knowledge, chart, story, canvas, responsive, model, modeling, connection, tenant, version, multiple currencies, display issue, BW BEx query, BW on HANA 7.5 SP28, Target Currency prompt, '#' symbol, '*' symbol, ##, #, hash, hashtag, star, multiple , KBA , LOD-ANA-DES , Story Design & Visualizations , LOD-ANA-LDC-BW , SAC Live Data Connection BW , LOD-ANA-LDC-HAN , SAC Live Data Connection HANA , Problem

Product

SAP Analysis for Microsoft Office all versions ; SAP Analytics Cloud all versions