Creating an OpenStreetMap

This topic describes how to add a new OpenStreetMap Object to a Screen or a Container and its specific properties.

To create a new OpenStreetMap, you need to access a Screen in Design mode.

Once you're in the Screen editing page, locate the OpenStreetMap Object from the Screen Objects list in the left panel, then drag and drop it onto your Screen or Container.

When you create an OpenStreetMap, it is initially empty. The next step is to configure a Layout that will define the data to be displayed in the map. To do so, click the center of the Object or select the OpenStreetMap Object and click the "Configure layout" button located in the Properties toolbar located along the Properties panel to the right of the Screen.

The OpenStreetMap, just like every other Object, can be moved, resized, duplicated via copy/paste, and easily aligned with other Objects on the Screen.

OpenStreetMap Layout

The Layout editor for OpenStreetMap Object is slightly different from the classic one, in that it offers map-specific options and must contain specific Data Blocks needed for mapping.
The main elements that should be considered are highlighted in the image below:

The Data area

Geocoding can be achieved in two way via Data Blocks:

1. Using Latitude and Longitude Cubes (for Map Areas and Bubbles. See Object settings for more details)

2. Using an Entity/Text Block whose members/text strings are mapped to IDs of SVG areas in a GeoJSON file (only for Map areas. See Object settings for more details)

Using Latitude and Longitude Cubes

1. Add the Latitude and Longitude Cubes to the Data area of the Layout editor. These two Cubes must contain the geographic coordinates regarding members of the Entity added to the "Markers" field

2. Add an Entity to the "Markers" field: Data Cubes added to the Data area should also have this Entity (or another Entity from the same Relationships tree) in their structure

   Example

   You want to visualize data from your Net Sales Cube which is dimensioned by Day, Shipper, Product, and Branch.

   The Branch hierarchy is the following:

   

3. To plot your data in the OpenStreetMaps Object, add two different Cubes dimensioned by Branch to your Layout: one containing Latitude coordinates and the other one containing Longitude coordinates of each member of the Branch Entity

   The following Data View shows those coordinates for each member of the Branch Entity.

   

   The following Layout definition will then visualize your data on the map, provided you have configured Bubbles and Map Areas in the Object settings area (see next paragraph for more info):

   

   As you can see in the example above, the "Customer" Entity is in the "Markers" field in the Axes area and all Cubes in the Layout have the Customer Entity in their structure.

   Data Cubes must have in their structure the Entity added to the "Markers" field or another Entity from the same Relationships tree at any level of aggregation.

   ​The Markers field where you set at least one Entity in the Axes field.
   

   

   To obtain geographical data, you can use various online providers (free or paid) or enter those values yourself through data-entry actions in corresponding Cubes.

Using an Entity/Text Block

1. Add an Entity/Text Block whose members/text strings are mapped to IDs of SVG areas in a GeoJSON file to the Layout

2. Go to the Object settings area of the Layout and select the "Map Areas" menu. To access these settings, you must first enable the "Map Areas" toggle.

3. Select the above Entity/Text Block from the "Shape name" dropdown under the "Map Areas" menu in the Object settings area of the Layout

   The GeoJSON file must contain IDs and coordinates for each map area while the Entity/Text Block in the Layout must contain the same IDs as member codes (Entity) or text strings (Text Block).

   Data Cubes added to the Data area should also have the Entity added to the "Markers" field - or another Entity in the same Relationships tree - in their structure

   Example

   You want to visualize data from your Net Sales Cube which is dimensioned by Day, Shipper, Product, and Branch.

   The Branch hierarchy is the following:

   

4. To plot your data in the OpenStreetMaps Object, add an Entity/Text Block containing the IDs of the SVG areas included in the GeoJSON file you want to use to your Layout

5. Then you will need to map the Block containing the IDs to the GeoJSON file, from the "Map Areas" menu in the Object settings area
   Using an Entity, the Layout configuration should look as follows:
    

   

   
   The Country Entity contains the following members, whose code is also used to identify map areas in the GeoJSON file:
    

   

Data Cubes must have the Entity added to the "Markers" field or another Entity from the same Relationship tree at any level of aggregation in their structure.

The Axes area

In the Axes area, you can add dimensions to define markers that will be used to plot bubbles in the map or to highlight map areas.

The Google Maps Object supports up to 2 Entities in the "Markers" field. For geocoding using Latitude and Longitude to work correctly, the dimension (Entity) used in the structure of Latitude and Longitude Cubes must be added to the "Markers" field as well. See next paragraph for more info. For geocoding using an Entity/Text Block whose members/text strings are mapped to IDs of SVG areas in a GeoJSON file, you need to include the Entity/Text Block in the Layout and select it in the "Shape name" dropdown under the "Map Areas" menu. See Object properties and Upload GeoJSON for more details.

Based on the numbers of Entities set in the "Markers" field, two scenarios may occur:

1. Standard data set (single Entity). The value is shown in the marker form. The position is given by Longitude and Latitude Cubes

2. Clustered data set (two Entities). Data points are clustered together in Bubbles, and relevant information related to the data point and the two Entities is displayed in a popover

OpenStreetMap Object settings

In the Layout editor, under the Object settings area, the "Map areas" menu allows you to configure data visualization as a colored layer over relevant map areas.

Map areas

The configuration can be done  in two ways:

• Latitude/Longitude. Use Latitude and Longitude Cubes. Add these Cubes to the Data area in order to select them from the dropdown menus under "Map areas"

• Shape name. Map the Entity/Text Block to the ID of the SVG areas in the GeoJSON file via the "Shape name" field

Color

For both options, in the "Color" dropdown menu, you can select Blocks from the Layout and use them as drivers for the area's color, while the "Color opacity for data aggregation by" dropdown menu allows you to define a criterion that controls the color opacity.

The following examples show the two mapping options available.

If you select multiple Blocks in the "Color" dropdown list, they will also appear in the Object toolbar both in Design and Play mode under the "Shapes" dropdown list: from there, just select the Block you want to be used as driver for the map areas color.
 

Bubbles

The "Bubbles" menu allows you to configure Bubbles that will be plotted on the map using Latitude and Longitude Cubes in the Layout. You can also define which Blocks will be used as drivers for the Bubbles radius and color.

You can configure the Bubbles color to change dynamically by setting a color alert on the corresponding Block. See Block settings for more details.

If both the Bubbles and Map areas option are enabled, setting a color alert on the Block that drives the color setting for both options will apply the alert settings to Bubbles and Map areas. If you select multiple Blocks in the "Radius" and "Bubbles Color" dropdown lists, they will also appear in the Object toolbar both in Design and Play mode under the "Bubbles" dropdown list: from there, just select the Block you want to be used as driver for the Bubbles color and Radius (Value).

OpenStreetMap properties and settings

OpenStreetMap properties are available from the Object Properties panel on the right of the Screen editing page once the Object is selected and associated with a Layout.

The OpenStreetMap Object supports all options common to all Screen Objects and the following properties:

• Master Object. If enabled, clicking on a marker or a map area will update the data displayed by all other Objects on the Screen in order to show only the data relating to the clicked item. The Master object result is similar to applying a Screen Selection

• Disable Drill down. Disables the drill-down functionality, both in Design and Play mode

Main options: User Controls

The Navigation and Zoom options enable or disable users controls for panning and zooming, both in Design and Play mode.

Map Areas

The "UPLOAD GEOJSON" button allows you to upload a GeoJSON file to manage map areas at different levels of detail.

To do so, proceed as follows:

1. Click on the button. The GeoJSON configuration window appears:
    

   

   
   From there you can upload one or more GeoJSON files to create your Library that will always be available for all OpenStreetMap configurations

2. Once you've uploaded your files (or selected a previously uploaded file from the Library), you can set the maximum zoom level (from 0 to 19) and associate each level with the available GeoJSON files.
    

   

   Board includes two out-of-the-box GeoJSON files, one for the entire world to be used at zoom level 0 and one for US States to be used at higher zoom levels.

3. Click the SAVE button to save your configuration and close the window.

In the example above a JSON map has been associated with the zoom level 0 and another JSON map with zoom level 3: when users will zoom on the map, a JSON map layer will be displayed according to this configuration.

In the following pictures you can see the map behavior at zoom level 0 and at zoom level 3:

Default Drill down

You can configure a default drill down path saved in the map configuration that will deploy when end users select a Bubble and click on the Drill down button in Play mode.

Map areas don't support drill features.

To configure the default drill, proceed as follows:

1. Select a Bubble and click the Drill anywhere icon

2. From the popup window, select the Entity to drill down on and click APPLY. The configured drill is performed and data is displayed in a Data View

3. Close the drill down window and save the Screen. The configured Drill is now the default, both in Design and Play mode

End users will still be able to configure other drill down paths in Play mode, if they're allowed to do so. See next paragraph for more details.

Screen selections and selections made by the user using Selector Objects (if any) also apply to data in drill down windows.

Limit Drill down Entities

You can limit drill down paths that end users are allowed to configure by selecting the Entities the user can drill down on.

To do so, while in Design mode, click on "CONFIGURE" in the top right corner of the Drill anywhere window to enter the Drill anywhere configuration window. From here, under the Entities tab, select/unselect the Entities you want to show/limit to the end user. The selected Entities will be the only ones available to the end user during the Drill anywhere configuration in Play mode.

Drill-to-Screen

To allow users to drill-down from the map to another Screen within the same Capsule with a selection on the selected Bubble element, proceed as follows:

1. Select a Bubble and click the Drill anywhere icon

2. From the popup window, click on the "CONFIGURE" button in the top right corner of the window to enter the "Drill anywhere configuration" window, and click on the "Screen" subpage. Enable the toggle next to the Screen subpage title and select all the Screens you would like to allow the end user to drill to.

   These Screens will be the only ones available when conducting a Drill-to-Screen from the Object in Design and Play mode, however, in Design mode, you can see any hidden Screens from the Drill anywhere window when you enable the "Show hidden" toggle in the top right corner of the window (which also shows you the hidden drills.

3. Click "APPLY" to close the configuration window.

4. From the Drill anywhere window, you can now further configure your Drill-to-Screen with the following options:

   • Select the "Same tab" checkbox to open the destination Screen in the same browser tab

   • Select the "New tab" to open in a new tab

   • The Drill to Screen mode, if enabled, will open the destination Screen with a selection on the row header (a member of the Entity set By Row) when the user double-clicks on it or selects it and clicks on the Drill-down icon 

   • The Go to Screen mode, if enabled, will open the destination Screen when the user double-clicks on a row header (a member of the Entity set By Row) or selects it and clicks on the Drill-down icon . The destination Screen won't inherit any selection from the Data View

   • The Dynamic Screen option allow to select a Block (an algorithm) to dynamically change the Screen navigation based on another Block values (a text cube containing Screen names)

5. Click APPLY to save the configuration

This feature allows you to nest your analysis in a more powerful way than the standard drill down, which only changes the level of granularity of a report. In a Drill-to-Screen navigation the data represented (values, indexes) and types of Objects (Charts, Dashboards, Data Views) may vary as the user drills from a top level view to another Screen at a more detailed level.

Screen selections and selections made by the user using Selector Objects (if any) also apply to data in the target Screen.

Drill-Procedure

It is possible to trigger a Procedure from a map when the user selects a Bubble and clicks on the Drill down icon. The Procedure is launched with a selection filter applied based on the clicked Bubble.

If a Drill-Procedure containing two or more procedures is configured, when the user double-clicks on a Bubble, a popup window allows the user to select the Procedure to run from a configured list.

To configure a Drill-Procedure, proceed as follows:

1. Select a Bubble and click the Drill anywhere icon 

2. From the popup window, click on "CONFIGURE" in the top right corner of the window to open the Drill anywhere configuration window and select the Procedures tab

3. Select the Procedures for the drill configuration. Choose whether the Procedure comes from the "Capsule" or the "Data model" and then select the Procedure from the dropdown menu (as described below)

   • Capsule. If selected, the dropdown menu to the right allows you to choose from a list of Procedures saved at the Capsule level

   • Data model. If selected, select a Data model from the dropdown menu on the right. By doing so, only Procedures belonging to the chosen Data model will display in the dropdown menu to the right

   After you've chosen the desired Procedure, click the ADD button on the right. Repeat the process for each Procedure you want to add to the drill

4. Enable Procedures with the corresponding toggle by the tab header to allow end users to configure a Drill-Procedure with the Procedures you just added

   If the Procedure toggle is left disabled, its configuration will not be available in Play mode.

5. Click APPLY to save the Drill-Procedure configuration and return to the Drill anywhere window

6. Double click a Procedure or select one and click APPLY to set a default Drill-Procedure.

Screen selections and selections made by the user using Selector Objects (if any) also apply to data in drill down windows.

Drill through

It is possible to execute a Drill through from a map when the user selects a Bubble and clicks on the Drill down icon. The Drill through is executed with a selection filter applied based on the clicked Bubble.

Drill throughs are configured in the Drill through section of the Data model.

To configure a Drill through on Bubbles, proceed as follows:

1. Select a Bubble and click the Drill anywhere icon ( )

2. Click on the Drill through tab to view

   If the Drill through feature is enabled from the "Drill anywhere configuration" window, a "Drill through" tab will be visible. If the Drill through feature is enabled and you would like to configure a Drill through on a row header that is not part of the list you configured as available to end users, you can do so by enabling the toggle "Show hidden" and selecting a hidden Drill through. If the Drill through feature is disabled, you can still apply a default Drill through by enabling the "Show hidden" toggle in the top right corner of the window and selecting a Drill through.

3. Double click the Drill through or select one and click "APPLY" to save the Drill through default configuration.

   You can also double click on the Drill through which will save the configuration and close the window (and you can skip the 4th step)

In order to configure which Drill throughs the end user can use and see in Play mode, proceed as follows:

1. Depending on the chart type, select a data point (a bubble, a bar, a rectangle, etc.) and click the Drill anywhere icon , or you can double click on a data point if a default Drill has not already been configured

2. From the popup window, click on the "CONFIGURE" button to open the "Drill anywhere configuration" window

3. Select the "Drill through" tab. Enable the toggle next to it and add the desired Drill throughs you'd like to be available to the end user below. If the toggle is not enabled, the Drill through drill down will not be available within the Drill anywhere window (when accessed by the Object toolbar) for designers or end users

4. Click "APPLY" to save and return back to the Drill anywhere window where you can now configure a default Drill through

5. Click APPLY to save the Drill through configuration.

Screen selections and selections made by the user using Selector Objects (if any) also apply to data in drill down windows.