How to create Geomap while using HANA analytic view ( HCP) as a datasource?

[Former Member]

Hello Experts,

I am referring to this blog - and while I try to execute the same steps to create a Geomap on BO cloud, I do not get any option to change any of my dimensions in the model. I am using SAP HANA Analytic view as the source ( through Live Data Connection). Here we need to create a Location dimension but do not get any option to do this.

Can you provide your helpful inputs please?

Thanks,

Megha

[JohnL · Accepted solution]

Hi Megha,

At high level you'll need to:

• Prepare HANA system for GeoSpatial location dimensions (Spatial Reference System; 3857)
• Create table with ST_POINT based on 3857 reference
• Convert the data
• Build the analytical view + attribute view
• Consume it in BOC

See the attachment Manually Enriching a HANA View.pdf' in the following release note for more information:

https://launchpad.support.sap.com/#/notes/0002291582

These videos are also useful for Geo Spatial in HANA:

[SAP HANA Academy] Geo Spatial in SAP HANA: Creating Spatial Type Data from an Existing Table

http://scn.sap.com/docs/DOC-57435

[SAP HANA Academy] Geo Spatial in SAP HANA: Importing Data from a CSV File

http://scn.sap.com/docs/DOC-57329

HTH

[Former Member]

Hi Megha,

The reason you cannot follow the steps in the blog is because of your Live connection. This works differently.

You'll need to prepare the geospatial data within HANA Studio. See this link for more information. Unfortunately, some geospatial analysis features will be automatically disabled. These include map filters and the choropleth layer.

For dimension modeling using a HANA view you'll need to access the model-preferences-dimension settings. More info here.

You might consider creating a flat file with your GEO data and use this as model. This allows for more flexibility and options.

Kind regards,

Clemens

[mrwong05]

How to combine a flat file with hana (2.0) live data on Lumira Server (2.3)?

Is it possible at all to display location data with HANA live data connection on Lumira Server on BIP 4.2?