Map (Datablocks)


Overview / Description

Map datablock allows you to display your measures/dimensions based on the geographical location.


Common Use Case

Map can be used to depict the number of sales achieved at a different geographical locations.


Pre-requisites

  • Need create a geocode dimension for the index (in “latitude, longitude” format)

To show a cube report on the map, a geocode dimension needs to be created in the index.

1. The name of the geocode dimension can be any name,

  • e.g. Location, but the value of this dimension needs to combine latitude and longitude with a comma, i.e. "lat, long", or

  • create a source table in SQL DB which contains latitude and longitude column and city or country column.

2. You can join “lat, long” to create a geocode dimension in your index, also having city or country using Reference Query.

3. Once the index is created, you can create a map datablock and choose the dimension data source.


Add Map to a Page

1. Select the page where you want to add a datablock. In this example, Training Demo page is selected.

2. From Edit Page menu, select Add Content.

The Add Content setting will display.

3. Input the number of datablocks you want to add to the page, then click Add.

The Select Datablock sub-setting will display.

4. Select Cube Report from the datablock options.

5. Update the Datablock Title and Datablock Style accordingly.

6. Click Add.

The added datablock will display on the page.

7. Under Edit Page menu, select Save Page to save the datablock in the page.

Once the changes have been saved, a success message will display on the top right corner of the screen.


Choose Datasource for Map

The Map datablock is blank by default upon adding it to the page and needs to have a data source.

1. On the datablock header, click the Choose Datasource icon.

The Choose DataSource setting will display.

2. Select a datasource to display on the datablock. In this example, the datasource will be selected from Dimensions tab.

  • Under Measures, select any measure.

  • Under X-Axis, select the geocode dimension that has latitude and longitude information.

The Map will display according to the selected data source. It shows the measure value for each point when hovering on the map icon.

If the measure is a KPI, the color of the map icon will also follow the thresholds of the KPI.

3. Under Edit Page menu, select Save Page to save the datablock in the page.


Link Map to Cube Report

You can also link the map’s data points to a cube report to explore the details behind the map.


Link Map to Drillthrough

In order to link to drillthrough, the data source of the map should be location dimension.

After linking, clicking on the map will show related data records on drillthrough.


Marker Clustering

eMite now has clustered Markers to make it easier on the eye. When the Data Markers are too close to each other, they will merge and obtain "Worst" status of the group. 

The merged value is sum of the all the children nodes values.

When zoomed in sufficiently, the data marker will show itself.


Map UI Controls

Change Type

Change Type allows you to change the display mode. The default display mode is Basic.

 

 

To learn more about the other map UI controls, go to UI Controls.