SAP Knowledge Base Article - Public

3589659 - Geo Map chart notification: "Location filter cannot be loaded." in SAP Analytics Cloud (SAC)

Symptom

 

  • When filtering in the Geo Map, "Filter selected data points on the location layer" is greyed out at the last hierarchy level of the location in the SAC.
  • Notification: "Location filter cannot be loaded."

Environment

SAP Analytics Cloud

Reproducing the Issue

  1. Login to SAC.
  2. Open the story where a Geo Map chart and a table is inserted, and linked analysis is set for those widgets.
  3. In the up left corner of the Geo Map chart, select the icon hierarchy: Navigate up/down the hierarchy.
  4. Select the dimension Location under your layer.
  5. Select the lowest hierarchy level e.g. Sub-Region 2.
  6. Select one of the bubbles on the map and right click => Filter will be available.
  7. Now Filter => OK, filtering will happen both Geo Map and the table.
  8. Right click - Filter => OK, filtering will happen both Geo Map and the table.
  9. Select again on one of the bubbles and right click => Filter will be greyed out with notification: "Location filter cannot be loaded." Even though there will be a possibility to drill down more.

Cause

  • This behavior is by design.
  • The choropleth layer has 4 shape levels (Country-Region-SubRegion1-SubRegion2) and it is allowed at the bottom drilling below to the actual data points (which is the same as the bubble layer) in SAC.
  • Creating filters on individual data points is not supported, hence why the option is disabled with the warning.

Resolution

  • Workaround: In the Linked Analysis, change the settings to either 'All widgets on the Page' or 'Only selected widgets' so 'Filter on Data Point Selection' can be enabled. This will trigger a Linked Analysis filter when the individual data point is selected.
  • Please, open an enhancement request for the topic per KBA 2424376 - How to create an enhancement request for SAP Analytics Cloud?

This document and SAP‘s strategy and possible future developments are subject to change and may be changed by SAP at any time for any reason without notice.
This document is provided without a warranty of any kind, either express or implied, including but not limited to, the implied warranties of merchantability, fitness for a particular purpose, or non-infringement.

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-GEO , SAP Analytics Cloud Story GEO visualizations , Problem

Product

SAP Analytics Cloud all versions