Skip to Content
0

Data selection for Design Studio Geo map component

Jun 10, 2017 at 10:33 AM

105

avatar image
Former Member

Hi Gurus,

I have 2 questions related to the data selection for a geomap component:

1. What is the best way to select data for geo map component points when there is a large dataset to be displayed in the map. Is there a way to select the data dynamically using scripting and passing it to the geo map layer or a expression in the select data screen for each layer? In the example below I have 200 points and when selecting the data I would like to avoid selecting each entry in the select data option.

2. How to select a measure in a geo map layer when values are 0. This source is based on a Bex query and is displaying a dynamic counter for last week period but when there are no entries for last week I cannot select the measure in additional properties if measure = 0 and is giving me an error (see below). It works fine if there are entries with measure <> 0.

Datasource Initial View for current selection

Select data in geo map layer

Layer definition

Error when running the application

Your help is very much appreciated.

Thanks,

Luis

ds1.jpg (40.2 kB)
ds2.jpg (12.2 kB)
ds3.jpg (26.0 kB)
ds4.jpg (22.3 kB)
ds5.jpg (16.6 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Mustafa Bensan Jun 12, 2017 at 03:47 AM
0

Hi Luis,

See my comments below:

1. It seems that you want to select all items in a data source. If this is the case, you do not need to use the data selection dialogue at all because the map component will consider the entire result set if you don't explicitly specify a selection. Even in the selection dialogue you can select an entire column as per your example by clicking on the column header, without the need to click individual rows. Perhaps I have misunderstood your issue? Can you clarify it further?

The Geo Map component itself does not have any scripting functions to influence data selection. You can however apply scripting functions directly to the data source assigned to the Geo Map, such as setFilter() etc.

2. Have you tried setting the desired measure with a data set where the measure <> 0, just for the purposes of selection in the Layer Definition. In that case, what happens when you execute the application and then apply a filter that results on null measure value?

Regards,

Mustafa.

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Jun 14, 2017 at 12:38 PM
0

Hi Mustafa,

Thanks for your clarification regarding item 1. I just thought that you needed to select the dimension as well to be able to read the long/lat data in selection dialogue. I guess then that selecting the measure column will also select the dimension entries.

Regarding item 2, I initially tried this with a measure <> 0 but when the time period changed to a period where there are no entries where measure <> 0 then I get the error as shown above.

Many thanks,

Luis

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hi Luis,

Regarding "I guess then that selecting the measure column will also select the dimension entries", there is actually no need to explicitly select the measure column either. There should only ever be one geo dimension defined in the data source and the geo map will automatically pick this up.

Regarding item 2, it seems that the Geo Map does not gracefully handle the cases of no data, resulting in the error. You could try your luck opening an SAP Support Ticket and making your case that this is a bug.

Regards,

Mustafa.

0