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 nameIf the location name is not unique, set a unique identifier for the attribute and use the location name as the default label.
One field with the latitude information
For latitude, use positive values for the Northern hemisphere, and use 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 use 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.
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 add the latitude and longitude information as labels manually and map them to appropriate columns.
For more details, see the Add New Label section in Manage Labels and the Map the LDM to the PDM section in Create a Logical Data Model Manually.