Skip to main content

logoCorrectSize.png

Adaptive Insights LLC.

Add Geo Region Coordinate Data to Dimensions and Values

Add latitude and longitude information to custom dimensions to create geo maps.

Only available with Adaptive Insights for Sales

Geo maps require a custom dimension that contains dimension values defining geo regions, and custom properties that define the region's latitude and longitude coordinate. 

You can create a list dimension or a hierarchical dimension. Hierarchical geography dimensions let you analyze data along the hierarchy. For example, view a broad regional perspective of aggregate data for countries, then narrow down to a specific country for states, specific state for counties, and specific county for zip codes.

Before You Begin

Create a custom dimension with dimension values for the geographic regions you need. Geo maps can support any geographic hierarchical model for a custom dimension if there are defined coordinates for each location.

 

How You Get There

Navigation Icon5.png From the nav menu, select Modeling. From the Levels and Dimension menu, select  Dimensions.

Add Coordinate Data to Your Dimension and Dimension Values

To add coordinate data to your dimension, you need to add two custom properties to your dimension, then enter custom property values for each dimension value. 

Add Latitude and Longitude Custom Properties 

  1. Select the dimension that contains geographic regions.
  2. Select Custom Properties, then add two custom properties with Add property. One property for latitude and another property for longitude. For example:
    Property 1:
    Latitude
    Property 2:
    Longitude

Import Coordinate data for Your Dimension Value Regions

  1. Download the dimension structure with the Generate Printable View. 
  2. Open the download in Excel.
  3. Add latitude and longitude coordinates for regions in the corresponding dimension value property columns. 
  4. Select Import Dimension Structure, then update the dimension structure to include the latitude and longitude coordinate data.

After you add the dimension to a modeled or cubed sheet, you can create a geo map. The dimension is used for the geo map's Geo Dimension field. 

 

  • Was this article helpful?