Skip to Content

SAP Analytics Cloud - Problem with Geo Dimension by Area Name

Hello there!

I am writing for some problem with SAP Analytics Cloud.

I am working with SQL Database - Northwind in Microsoft SQL Server 2014. When I am creating model from SQl Database. I cannot create Geo Measure in the model for making story with maps.My database does not have columns for longitudes and latitude. So I tried with Area Name. I tried with Region-City, Region-Country, City-Country and etc.

At the screenshot is showing the problem!

cloud.png (119.5 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Jan 11 at 04:38 PM
    Add comment
    10|10000 characters needed characters exceeded

  • Jan 11 at 05:28 PM

    Hello Galina,

    There are two ways to define Geographical data for your model (By Coordinates; By Area Name/By Region).
    As I can see you would like to use the "By Area Name", as you have no coordinates defined.

    Unfortunately this is currently supported for the USA only:

    Please check the below online help page for further details:
    https://help.sap.com/doc/00f68c2e08b941f081002fd3691d86a7/release/en-US/c52a875d319b4cd1890a52f6286f96bc.html

    I would suggest to add a latitude and longitude columns in database level and use the coordinates option.

    Best Regards,
    Mate

    Add comment
    10|10000 characters needed characters exceeded