SAP Knowledge Base Article - Public

3532600 - Limit of coordinate points that can be displayed in Geo Map widget in SAP Analytics Cloud (SAC)

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

  1. Log on to SAC.
  2. Open story affected.
  3. Select all values for location filter.
  4. Notice the errors popping up, selection is not being applied.
  5. 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

Your feedback is important to help us improve our knowledge base.

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, connected, failure, stopped, sap analyst cloud, https://hcs.cloud.saphttps://hanacloudservices.cloud.saphttps://cloudanalytics.accounts.ondemand.comhttps://hanacloudservices-us.accounts.ondemand.comhttps://www.sap.comhttps://help.sap.com, predictive analytics (analysis), data analysis (analytics) tools, analytics tools, sap analytics cloud, data literacy, advanced analytics, data democratization, analytics software, real time analytics, self service analytics, advanced data analytics, analytics as a service, analytics cloud / cloud analytics, saas analytics, cloud bi, enterprise planning, cloud data analytics, cloud based analytics, analytics cloud platform, modern analytics, real time analysis, cloud analytics solution(s), what is sap analytics cloud, cloud analytics tools, analytics in the cloud, cloud analytics software epm, business intelligence
, KBA , LOD-ANA-DES , Story Design & Visualizations , LOD-ANA-DES-COR , SAC Core story functionality - widgets, geo, design, etc , Problem

Product

SAP Analytics Cloud all versions