How to get geolocation data through CDS view?

[ventior]

Hello guys,

for a dashboard we need to add in the geomap in the SAP Analytics Cloud. For this we've created a custom Query and custom cds views.

For the geolocation data we query it in a dimension like so:

define view ZD_SD_CUSTLOC as select from geot005 {
    @Semantics.address.country: true
    key land1 as Country,
    @Semantics.geoLocation.longitude: true
    longitude,
    @Semantics.geoLocation.latitude: true
    latitude,
    altitude
}

Sadly, when tryign to use these as a Location Dimension in a geomap, we simply get the warning "Location Dimension required", with the list of the associated objects being empty.

What is needed that the Dimension gets recognized as a Location Dimension?

[MKreitlein · Accepted solution]

Hello @ventior,

I'm not sure if you can achive this via a CDS view... at least the SAP Help page describes how to achieve this via a HANA Calculation view: https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/f7f432923cd9495bb5c98... 

Hope this helps anyway... or you find some more hints on these pages.

BR, Martin

[ventior · Accepted solution]

Oh, thank you! I was confused because I was sure it would be possible if the annotations existed. Guess I was wrong. Thank you!