Adding the Choropleth Layer

Visualize your dimensions and measures by displaying shaded geographical shapes or bubbles in a choropleth layer.

Prerequisites

To add data from a model to a choropleth layer, the model must contain at least one location dimension. For more information, see Creating a Model with Coordinate or Area Data for Geospatial Analysis.

Note

If your SAP Analytics Cloud system is hosted on a data center located within China, or you are accessing a system assigned to an SAP India customer, this feature is not available.

Note

For SAP BW live connection, consider the following:

The model does not explicitly contain a location dimension like SAP HANA models. The dimension needs to be configured in SAP BW as geo relevant. To use the choropleth layer in SAC, the attributes 0LONGITUDE and 0LATITUDE need to be maintained. For more information, see Editing the Settings for BI Clients.

For SAP BW 7.50, run the report rsd_geo_sync_attr to fill the SAP HANA geo table and fill the 0GEOFEATID attribute values.

For SAP BW/4HANA 2.0, the SAP HANA geo table is filled automatically. Fill the navigational attribute 0GEOFEATID via transformation.

Note

You need to have the SAP Spatial DU available for Live SAP HANA models.

For more detailed information on prerequisites to display the choropleth layer in an SAP BW live connection, see Using Geo-Relevant Characteristics in SAP Analytics Cloud.

Procedure

To pick the model that the layer will be based on, under Data Source, select (edit).
If you have associated a model with a previously added layer, this data source will by default appear under Data Source. Use (edit) to change the data source.
Select Choropleth / Drill Layer from the Layer Type list.
Choose one of the following Style options:
- Choropleth – shaded geographical shapes will be used to visualize your data.
  Note
  
  If you experience slow rendering performance due to a large number of shapes, you can switch to bubble style for minimal rendering.
- Bubble – using the choropleth layer hierarchy, bubbles are used to display your data.
  Note
  The point where the bubble is rendered is the centroid of the underlying shape and not a precise location based on coordinates.
From the + Add Location Dimension list under Location Dimension, select the dimension that you want to visualize.
Under Choropleth Color, select a measure from the + Add Measure list to determine the values to color on your map.
1. Select a color from the Palette list.
  Use the swap icon to reverse the palette order.
2. If necessary, adjust the Opacity of the layer.
3. Choose the number of Ranges for the palette.
4. Specify values to set the KPI ranges for each color in the palette.
When displaying bubbles on a choropleth layer, if you choose to associate Choropleth Color with a dimension, the dimension's top five members are displayed in pie charts within the resulting bubbles. If no measure is specified for Bubble Size, the pie sections will be evenly proportional. If a measure is specified, the proportion will be aggregated according to the measure values. To highlight a bubble, select it once. To highlight a section of the pie within a bubble, select the bubble and then select the section. If you associate Bubble Choropleth with a hierarchical dimension, you can drill up or down the hierarchy after selecting a bubble or section.
Note
You can only sync colors by dimension using a geo map and a chart.

Note
You can associate Choropleth Color with only one dimension or measure when displaying bubbles in a layer.
Select OK to save all layer settings.
You can create a filter for the layer.
Choose a shape in the map and select the (Filter) icon to remove data points outside the selected area. Choose to exclude all data points within the filter. Select (cancel) icon to remove the filter. You can also remove parts of the drill path by removing them from the Location Filter token. You can use the Drill Filter control at the top of the geo widget to navigate back on the drill path or to remove the filter.

Note
To drill a layer above or below current geographic shape, select either the (Drill Up) or the (Drill down) icons. Drilling on a region will filter out any data from other regions. You can also remove parts of the drill path by removing them from the Location Filter token. You can also drill down to the individual data points if the model was originally enriched by coordinates.
To control the display of data point labels in the geo maps, select the geo map and go to More Actions Show/Hide Labels) to display or remove labels for a particular layer.

By default, labels will display inside or undereth the bubble, and labels will not overlap. However, to remove the automatic control on label overlap, choose Designer and select (Styling). Turn Off the Avoid Data Label Overlap under Labels.
1. To display values for measures, you can go to More Actions Show/Hide Labels, select the corresponding layer, and under Measures select the measure(s) for which you want to display values.
To filter from the designer panel, select a value from the +Add filter list and choose the members you want to filter. Click OK to activate the filter. You can then see your filtered members as selected in the filter box and the map displays the regions the filtered members are contained in. Select the (cancel) icon to remove the filter.
Draw a polygon filter on the map for customized filtering. Choose (polygon filter tool) from the panel on the left-hand side of the geo map.
1. Select the (Filter) icon to display the regions within the polygon shape only.
2. Click the frame of the polygon and choose to exclude all data points within the filter.
3. Click the frame of the polygon and choose (cancel) to remove the filter.
To customize the data that displays for a given data point in the layer, select the icon to right of Layout. You can also use the (More Actions) icon to the right of the geo map to access Add Tooltip for a specific choropleth layer.
- Select Tooltip Information to specify information that will be displayed when you hover over a given data point in the geo map. Use the provided Tooltip Information field to choose from a selection of measures, dimensions, and dimension attributes, or to create a calculated measure or measure input control.