Configure Data for Geo Charts

Prepare Your Data

To use geo charts in Analytical Designer, you must include the geographical information in your database as separate columns for longitute and latitude.

You can add geographical information to a current dataset in your logical data model or you can create a new dataset with the geographical information.

The dataset must include:

  • One field with the location name

    The location name represents the name that is displayed in geo charts - for example, a city, a branch, or a store.

  • One field with the latitude information

    For latitude, use positive values for the Northern hemisphere and negative values for the Southern hemisphere. Do not include spaces.

  • One field with the longitude information

    For longitude, use positive values for the Eastern hemisphere and negative values for the Western hemisphere. Do not include spaces.

Create a New Dataset with Geo Information

If you create a new dataset with geographical information, you must convert the geo information to the Geo latitude and Geo longitude labels and assign them to the location name of the attribute.

The labels are automatically mapped to appropriate source columns in the database.

Convert labels

For more details, see the Convert Attribute or Fact to Label section in Manage Labels.

Add Geo Information to an Existing Dataset

If you add the geographical information to an existing dataset, you must manually add the latitude and longitude information as labels and map them to appropriate columns.

Map labels

For more details, see the Add New Label section in Manage Labels.