Symptom
Count operation counts the distinct value of the selected dimension in SAP Analytics Cloud(SAC).
Environment
SAP ANALYTICS CLOUD 2025.1.14
Reproducing the Issue
- Log on to SAC
- Open story and add table widget
- Add a calculation for Count at 'X' dimension
Notice: the count operation gives the distinct count value for 'X' dimension.
Cause
- This is by design behavior of the product.
- Count function counts the number of the distinct values present the selected dimensions with values for a specific measure, including null values.
Resolution
Create an enhancement request if you want to request showing of repetitive members with count function. Refer KBA: 2424376 How do you create an enhancement request and provide feedback for SAP Analytics Cloud?
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 an case for SAP Analytics Cloud?
- 2511489 - Troubleshooting performance issues in SAP Analytics Cloud
- Search for SAP Analytics Cloud content using Google or Bing:
- 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!
Keywords
Sap Analytic cloud, SAC, Count, aggregation, measure, dimension , KBA , LOD-ANA-DES-CAL , SAC Story Calculations , Problem
Product
SAP Analytics Cloud all versions