Symptom
The following error message occurs in SAP Analytics Cloud (SAC):
- When activating all locations on geo map with bubble layer, the following error is being displayed:
Warning [Server]: (#42758) A constraint of the dimension, which can't be aggregated, is violated : These dimensions must not be aggregated, but are not in drill or filtered by a single member: [Account]
Info [Server]: (#42768) The Cube that exceeds the limits contains the following dimensions : Rows:
Member_Location_2_G2v4mw656w493k], Columns: CustomDimension1]
nfo [Server]: (#42709) The selection returned more records than the limit in MaxResultRecords : actual/query/default = 8652486/5000000/1000000
Info [Server]: (#42709) The selection returned more records than the limit in MaxResultRecords : The selection returned more records than the Unit in MaxResultRecords : Number of data records exceeded: 8652486
Environment
SAP Analytics Cloud Version 2024.15.11
Reproducing the Issue
- Log on to SAC.
- Open story affected.
- Select all values for location filter.
- Notice the errors popping up, selection is not being applied.
- When selecting just a couple of these values, geo map is working as expected.
Cause
- The query with all filter values selected returns over 8 million records.
- SAC has a query limit of 5 million records. This limit is in place due to performance stability and there is no way to override it.
Resolution
- For geo it is recommended that with large data volumes, use the choropleth layer instead of the bubble layer.
- The choropleth layer aggregates the data into region shapes which you can drill up/down on to see different levels of detail.
- For large volume of data it is better to initially show the aggregated data for all of the selected country, then drill down to show the aggregated data per state, then sub-region, etc.
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