Creating Location Dimension

[arijit_das]

Can't we first create a location dimension first and then use that in multiple models? I want to first create the analytic model and then import data into it from excel. In this case, I am unable to use geo map as there is no location dimension detected. I have a dimension with lat, long info as attributes.

I do not want to create the model directly from excel data as I want to re-use some existing dimensions.

[TammyPowlas]

I recommend voting on this idea in Idea Place - https://influence.sap.com/sap/ino/#/idea/208312 - creating a public dimension. The idea is under review.

[JohnL]

Yes see https://apps.support.sap.com/sap/support/knowledge/public/en/2433853

[julian_jimenez · Accepted solution]

Hi Arijit,

As Tammy recommended, you should vote for that idea.

You can prepare a model with Geo location and later import new data using "import data from file" to update measures dimensions and locations.

For HANA live models it's easier as you only need to select what is the calculation with the location.

https://help.sap.com/doc/00f68c2e08b941f081002fd3691d86a7/release/en-US/f7f432923cd9495bb5c98d5cdd66...

Regards,

Julian

[arijit_das · Accepted solution]

Thanks Julian & Tammy.

[JohnL · Accepted solution]

Hi Arjit,

See https://apps.support.sap.com/sap/support/knowledge/public/en/2433853 as well.

[arijit_das · Accepted solution]

Thanks John. This SAP KBA clears all doubt.