Esri Maps for MicroStrategy (v2.0.2 Archive)

In this topic
  1. Create a simple report
  2. Insert a map visualization
  3. Add MicroStrategy data to the map

This is an archive related to a previous version of Esri Maps for MicroStrategy. If you need the current version go to http://doc.arcgis.com/en/maps-for-microstrategy/.

Build a map-enabled report

To include an interactive map in a MicroStrategy report, you must add a map visualization in MicroStrategy Web and specify the data you want to visualize. This data can then be added to your map in Esri Maps for MicroStrategy.

A map is a spatial document composed of one or more layers. A layer is the way in which Esri Maps for MicroStrategy visually represents geographic datasets. A layer is similar to a legend item on a paper map. For example, on a road map, roads, national parks, political boundaries, and rivers might be considered different layers. When you add data from MicroStrategy to a map, Esri Maps for MicroStrategy creates a layer and displays it on the Contents pane. Once the layer is created, you can configure how it is styled, set its transparency, enable clustering or heat maps, turn on pop-ups, and so on.

When you add data to a map in a MicroStrategy report, you add data from a single dataset, which becomes one or more layers on the map.

Create a simple report

Create a simple report and add attributes and metrics to it. This data can later be added as layers on the map.

  1. In MicroStrategy Web, create a blank report.
  2. Add attributes and metrics to your report.

    You must include at least one location-based attribute, such as address data or longitude and latitude values. For a complete list of location types supported in Esri Maps for MicroStrategy, see Location types.

Insert a map visualization

You can include one map in your report. Add a map by inserting a custom map visualization in MicroStrategy Web.

  1. After adding attributes and metrics, press the Run Report button on the toolbar.
  2. Ensure that the Custom Visualizations Editor is enabled in the MicroStrategy Web project defaults. See the MicroStrategy Web Help for more information.
  3. From the Tools drop-down menu, choose Custom Visualizations.
  4. In the Custom Visualizations window, do the following:
    1. Check the Enable this report to use custom Visualizations check box.
    2. In the Available list, choose Esri Maps for MicroStrategy Report and press the arrow to add it to the Selected list.
    3. Press OK.
    4. Sign in to ArcGIS if prompted to do so.

      When you are successfully signed in, an Esri map visualization is displayed. You can now add data to the map.

Add MicroStrategy data to the map

Add the dataset you included in your report to the map. The dataset becomes a layer on the map.

  1. In the map, from the Add data menu, choose from MicroStrategy.

    The datasets you included appear in the add data from MicroStrategy pane.

  2. Choose the dataset you want to add and press Next.
  3. Do one of the following:
    • Specify how location is represented in the current dataset by choosing one of the location types.
    • If you want to use a map service or feature service from ArcGIS as a location type, follow the steps in Add a location type.
  4. Press Next.
  5. Select and specify the values for the columns containing the location information. Ensure that there is a one-to-one relationship between the columns you select and the location type you chose.
  6. If you chose Latitude, Longitude for the location type, the default coordinate system that will be used is World Geodetic Survey (WGS) 1984. To specify a different coordinate system, do the following:
    1. Press the Advanced link.
    2. Choose the appropriate coordinate system for the data you are adding. Choose Other if your data is in a coordinate system other than WGS 1984 or Web Mercator.
    3. If you chose Other, type the well-known ID (WKID) of the coordinate system in the WKID text box.
  7. Press Next.
  8. Do the following:
    1. Choose the format of the column data that you specified, and choose the fields you would like displayed in your pop-ups.
    2. If you want the map to zoom to the full extent of the layer that is created when the data is added, check the Zoom to layer check box.
    3. If you want a different name for the layer, type a new name in the Layer name box.
  9. Press Add data to map.

    A layer containing the data is added to the map and is listed in the Contents pane. If you checked the Zoom to layer check box, the map zooms to the full extent of the layer you added.

The report now contains the map you configured. You can now change the way the map layer is styled, enable clustering or heatmaps, and so on. If your administrator has enabled printing for you, you can also print your map-enabled report in Run Mode once the map has loaded completely.

You can enhance your map with additional geographic data from ArcGIS. For example, your map may have MicroStrategy data showing proposed store locations and you want to add household income data from ArcGIS for those areas to visually analyze trends. For more information, see Add data from ArcGIS.

You can also filter data in your map in the same way you would any other report data. Filter your map data using the Page-by Axis tool, or use the View Filter tool to filter your data by attribute or metric. You can also configure dynamic links to launch an external report or document by making selections on the map.