Symptom
- Numeric Point widget not displaying data while the same data is displayed on a Table chart for example.
- For calculated measures, Numeric point widget is not taking into consideration unbooked data when calculating aggregation (example: average) value.
Environment
SAP Analytics Cloud Enterprise
Reproducing the Issue
- Login to SAC.
- Open Story.
- Notice that numeric point widget shows incorrect value for average calculation not taking into account the unbooked data.
- Table widget shows correct value.
Cause
For Numeric Point widgets, the current behaviour in optimised mode expects by design either a single select filter on the secondary structure if the structure is not added to the axis or expects the secondary structure to be added to the axis if multi selection filtering on that structure is needed.
Resolution
The current proposed solution is to add the secondary structure to "Trellis" under "Chart Add-Ons" in the Numeric Point builder panel.
See Also
- 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
- Have a question? Ask it here and let our amazing SAP community help! Or reply and share your knowledge!
- 2487011 - What information do I need to provide when opening a case for SAP Analytics Cloud?
- 2511489 - Troubleshooting performance issues in SAP Analytics Cloud
- Search for SAP Analytics Cloud content using SAP for Me, Google or Bing:
-
- https://me.sap.com/servicessupport/search#?q=SAP%20Analytics%20Cloud%20OR%20SAC&tab=All
- https://www.google.com/search?q=site%3Ahttps%3A%2F%2Fuserapps.support.sap.com+SAP+Analytics+Cloud
- https://www.bing.com/search?q=site%3Ahttps%3A%2F%2Fuserapps.support.sap.com+SAP+Analytics+Cloud
- Note: Add relevant text or warning/error messages to the text search field to filter results.
- SAP Analytics Cloud Connection Guide
- Getting Started with SAP Analytics Cloud Expert Community page
- SAP Analytics Cloud Get More Help and SAP Support
- Need More Help? Contact Support or visit the solution finder today!
Your feedback is important to help us improve our knowledge base.
Keywords
SAP, SAC, SAP Analytics Cloud, issue, numeric point, widget, table, average, unbooked, data , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem