Symptom
- 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.
Environment
- SAP Analytics Cloud
- SAP HANA Platform using Live Data Connection
Reproducing the Issue
-
Create a Calculation view in HANA adding a measure Counter with exception aggregation COUNT_DISTINCT
- In SAP Analytics Cloud, create a model using that Calculation View
- Create a story and use that model
- Create a new calculation "Restricted Measure" in the story
- Add a table and select to show totals displaying this measure
You will observe a - (unbooked / null) rather than the totals expected:
Resolution
- 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
- 2518716 - Calculated accounts do not show in Story totals
- Help resources and free SAP Analytics Cloud content
- Help portal
- SAP Community (Questions & Answers / Direct Link to ask question / Blogs)
- SAP Community WIKI
- Improvement requests (on the SAP Customer Influence portal)
- Video tutorials
- Videos by topic areas: (Overview, Models and Connections, Stories, SAP Digital Boardroom, Planning, Collaboration, Administration)
- Training events
- Past event recordings
- New user handbook
- Roadmap
- How to connect to on-premise data
- 2487011 - What information do I need to provide when opening incidents with SAP Analytics Cloud
- Introducing SAP BusinessObjects Cloud: BI and Planning (SAP Press book)
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.
Keywords
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