Geo-Reporting BW4-SAC: Missing BW shape dimension PLZ__0GEOFEATID

[hdutka]

Hi all,

When trying to use choropleth layer in SAC based on BW live connection, I get the following error: Missing BW shape dimension PLZ__0GEOFEATID

A similar problem is described here: https://answers.sap.com/questions/13297240/missing-shape-id-in-sac.html

The backend systems were configured as described in https://blogs.sap.com/2021/01/20/choropleth-layer-integration-with-sap-bw-live-connection-in-sap-ana...

In a nutshell, following steps were performed:

1. Configured HANA
2. Activated required BI-Content InfoObjects
3. Create Characteristic and flag it as geo dimension (InfoObjects got assigned automatically)
4. Set 0GEOFEATID as navigational attribute
5. Loaded data into 0LATITUDE/0LONGTITUDE (For german postalcodes)
6. Ran ABAP report “RSD_GEO_SYNC_ATTR” (Region ID was stored in 0GEOFEATID)
7. Ran ABAP report “RSD_GEO_SYNC_HIER”
8. Added Characteristic to ADSO and loaded data into ADSO
9. Created CompositeProvider/Query and added Characteristic with navigational attribute 0GEOFEATID

I attached screenshots for the data preview of the Query and the error message in SAC.

Any ideas what is causing the error?

Best regards