Skip to Content
avatar image
Former Member

SAP Analytics Cloud - Using Linked Models within a Geomap

Hi there

I have a transactional table (#1) of Sales data. One field is Country ID. I want to map those sales geospatially.

I have another table (#2) that contains Country ID and Lat & Longditudes.

I have successfully linked the two tables (models) by Country ID.

In Table #2 I have created a Country Location dimension using the Lat/Long coordinates.

However in Story mode I cannot use Table #1 AND Table #2 when i try to create a GeoMap. I can only use one OR the other.

In other objects (bar charts etc.) I am able to use the linked table fields...

What am I doing wrong? How can I map data in one Table using coordinate data in a linked Table?

Thanks in advance for your help!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Mar 06 at 04:28 PM

    Hi Rob,

    You are not doing anything wrong. As it is designed, when you select a Geo Map it only allows you to select measures from the model with the locations, even if you link models. As you mentioned, other type of charts don't have this limitation and you can display measures from a different model.

    There is already an idea that is similar to what you need:

    https://influence.sap.com/sap/ino/#/idea/140817

    If if doesn't exactly reflect what you need, you can create your own so product management is aware of the request:

    https://influence.sap.com/sap/ino/#/campaign/884

    Thanks,

    Julian

    Add comment
    10|10000 characters needed characters exceeded