Warehouse Structure for Your Logical Data Model » Supporting map data and Geo Location

Supporting map data and Geo Location

MicroStrategy can display data as part of an interactive map, which can include important information along with additional geographical information. This geographical data can be displayed using features such as the Map visualization available with Visual Insight, or through using the Map widget. This can quickly show you analysis such as the profit of stores on the east coast.

The Map widget can also use geographical data to return the location of a MicroStrategy Mobile user, which can be used to perform additional analysis. For example, the current location can be used to return detailed information on the company’s five closest distribution centers. This information can then be displayed in a map format on the device, as shown in the example below:

To utilize these geographical location features in MicroStrategy, you must have location data stored in your data source. MicroStrategy requires latitude and longitude data to recognize a geographical location.

You can use various methods to develop a list of geographical locations. The procedure below uses a third-party free utility to determine valid latitude and longitude values.

The third-party product discussed in this document is manufactured by vendors independent of MicroStrategy. MicroStrategy makes no warranty, express, implied, or otherwise, regarding this product, including its performance or reliability.

To create location data to support mapping features in MicroStrategy

To create location data

In the data source of your choosing, you must create the location data for the locations that can be recognized when using mapping features in MicroStrategy. This location data must include both a latitude and longitude, along with any descriptive information required to be displayed for each location. This procedure uses a third-party free utility to determine valid latitude and longitude points for given addresses.

1 In a web browser, go to the following URL:

http://www.gpsvisualizer.com/geocoder/

The GPS Visualizer’s Address Locator opens.

2 In the Input field, type the address to determine the latitude and longitude for. For example, 1600 Pennsylvania Avenue Washington DC 20500.

You can return latitude and longitude for multiple addresses at the same time. This procedure provides the steps on how to return the latitude and longitude for a single address.

3 In the Source drop-down list, select Google.
4 Select the Include extra fields in output (precision, city, country, etc.) check box to include additional information about the location. This additional information is not required, but it can provide additional details that can be displayed as part of the location.
5 Click Start geocoding. When the page has refreshed, click Create a GPX file. A new page opens with xml script. The latitude and longitude values are embedded in the xml as “lat” and “lon,” respectively. In the example picture below, these values are highlighted.

6 Include the values in quotation marks after lat= and lon= as the latitude and longitude of the location, respectively. You must store this data as numerical values that can support the decimal precision of these values.
7 Include any additional information in your data source for each location that you store a latitude and longitude for. This can be information returned from the geographical location search as well as data pertinent to your needs. For example, if you are storing addresses for distribution centers, you can include the name of the distribution center as well as any other pertinent information.
8 Repeat the previous steps in this procedure for all locations that you want to support when using mapping features in MicroStrategy.

If you do not have an entry for a given latitude and longitude point, no information can be returned for that geographical location.

To integrate location data with the Map widget

9 In MicroStrategy, create an attribute that can return all the location data for each entry. Separate attribute forms should be created for latitude and longitude, and should also support the numeric data of these values. The latitude and longitude attribute forms can serve as values to identify each attribute element. Attributes that use multiple attribute forms as their ID form are referred to as compound attributes. For additional details on creating an attribute, see The Context of Your Business Data: Attributes. For information on using two attribute forms to identify each attribute element, see Attributes with multiple ID columns: Compound attributes.
10 If you have additional descriptive information that you want to make available for display, create additional attribute forms for that descriptive information.
11 After creating this attribute, you can:
Create a Map widget to display this location data. For information on creating a Map widget, see the MicroStrategy Web Help.
Use Visual Insight to create a map visualization to display this location data. For information on using Visual Insight to create dashboards that contain mapping visualizations, see the MicroStrategy Web Help.