Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

GeoJSON file for compounded key 0REGION


I've tried to use a GeoJSON file in Design Studio 1.5 SP1 to display the states as shapes in the US.

The GeoJSON file contained the Feature "LSAD" with the abbreviated State as the property, e.g.

"LSAD": "AZ" for Arizona,

"LSAD": "AK" for Alaska,


My DS application used a BEx Query with the InfoObject 0REGION. This is compounded with the InfoObject 0COUNTRY.

This didn't work.

I then created a new InfoProvider with the non-compounded InfoObject REGION.

This worked.

My question is how must I write the property in the GeoJSON file correctly for the compounded InfoObject 0REGION?

e.g. for Arizona

"LSAD": "USAZ" or

"LSAD": "US/AZ" or

"LSAD": "US\AZ" or


or something else?

Please tell me if you know.


Former Member replied

Hello Martin,

my guess would be there is a " " (space) between the key values but the best way is to take a BEx query with the compounded values and use a crosstab and then just use a .getSelectedvalue on the crosstab for the onSelect and get the compounded key value


Ingo Hilgefort, Visual BI

0 View this answer in context

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question