Symptom
The correspondent business scenario, from the technical point of view, requires an SAP Analytics Cloud Story to be built.
It is wanted to use GEO map with Default Choropleth layer.
This feature enables the choropleth layer type for the geo widget in combination with BW datasources. Choropleth layers will display geo data using shapes, which are geographical areas defined as a polygon or multi polygon. All of these shapes are organized in a hierarchical fashion, meaning they contain children which are also shapes.
The BW Hierarchical representation of the Regions is handled by content Hierarchy "SAPBWWORLDHIERARCHY". It is the Hierarchy of 0GEOFEATID. SAPBWWORLDHIERARCHY will be available in the system once report RSD_GEO_SYNC_HIER in being executed, as it is described in KBA 2895865 - BW-Live GEO Default Choropleth Layer, Regions not available
By running report RSD_GEO_SYNC_HIER, the following error occurs:
Information Synchronize hierarchy for geographical region / feature ID
Check canceled due to errors
View _SYS_BIC.FPA_SPATIAL_DATA.choropleth/CHOROPLETH not found on DB
invalid table name: Could not find table/view FPA_SPATIAL_DATA.choropleth/CHOROPLETH in schema _SYS_BIC: line 1 col 50
View FPA_SPATIAL_DATA.choropleth/CHOROPLETH does not contain field LEVEL
Read more...
Environment
- SAP Analytics Cloud 2019.14 and upwords
- SAP NetWeaver 7.5 SP16 and upwords
- SAP BW/4HANA 2.0 SP4
Product
Keywords
FPA_SPATIAL_DATA.choropleth/CHOROPLETH, RSD_GEO_SYNC_HIER, CHOROPLETH , KBA , BW-BEX-OT-BICS-INA , BW INA provider , LOD-ANA-LDC-BW , SAC Live Data Connection BW , How To
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.