Skip to main content


Workday Adaptive Planning Knowledge Center

Add Geo Region Coordinate Data to Dimensions and Values

Explains how to add latitude and longitude information to custom dimensions to create geo maps.

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.


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:
    Property 2:

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. For sample latitude and longitude coordinate data, see Geo Map Coordinate Sample Data
  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?