SAP Knowledge Base Article - Public

2557079 - Totals in a table shows "-" instead of the Totals expected in SAP Analytics Cloud


  • After creating a table with some measures and one dimension, you add Totals.
  • Totals are correctly displayed for some measures but shows "-" for others.
  • Model is based on a Live connection to a HANA database.


  • SAP Analytics Cloud
  • SAP HANA Platform using Live Data Connection

Reproducing the Issue

  1. Create a Calculation view in HANA adding a measure Counter with exception aggregation COUNT_DISTINCT
  2. In SAP Analytics Cloud, create a model using that Calculation View
  3. Create a story and use that model
  4. Create a new calculation "Restricted Measure" in the story
  5. Add a table and select to show totals displaying this measure

You will observe a - (unbooked / null) rather than the totals expected:



  • This issue is resolved when the underlying HANA database is on revision 122.14 or higher
  • See SAP Note 2537514 - SAP HANA SPS 12 Database Revision 122.14

See Also

Your feedback is important to help us improve our knowledge base.
Please rate how useful you found this article by using the star rating feature at the beginning of this article.
Thank you.


undefined, SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Hana Cloud for Planning, EPM-ODS, Cloud for Analytics, C4P, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, HCP, C4A, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJ, BOBJcloud, BOCloud., BICloud, BO Cloud, connecting, conecting, conectando, conexão, modelo, SBOC, SAC, SAP BusinessObjects Cloud, Business Objects, SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics , KBA , LOD-ANA , SAP Analytics Cloud (SAC) , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , LOD-ANA-PL , Planning , LOD-ANA-BR , SAC Boardroom , LOD-ANA-PR , SAC Predictive , Problem


SAP Analytics Cloud 1.0