Geo map chart in Webi

[former_member731800]

Hi guys,

we have a table for suppliers with following columns name, city, street , longitude and latitude.

longitude and latitude are number columns and this coordinates belong to street not to the city

I have seen a video how to turn country or city into GEO Objekt but i am not sure how to set up the universe.

In the video seems simple just turn city into geo based on name but it doesn;t properly because the cities are sometimes in original languages and need to be set properly in the next step. If new city will be loaded in the table then can happend that it will be not set properly again.

There is another option turning the dimension by longitude and latitude but how?

We want to display supplier's name on the chart so is there a need to create universe object supplier's name as dimension plus 2 details objects for longitude and latitude?

thanks