KB47677: ESRI map displays city markers in incorrect locations when the city name exists across multiple states in MicroStrategy Web 9.4.1 and above

SYMPTOM:
In Strategy Web 9.4.1 and above, users can quickly create an ESRI map by importing city names and their corresponding states names using Data Import and mapping the columns to the City and State Geo-roles, without the need for the latitude and longitude values beforehand. However, when the name of the city exists in multiple states, e.g. the city of Darien exists in the states of Illinois and Connecticut, although the state information is generated correctly, displayed in the tooltip for Connecticut, the city latitude and longitude are incorrectly generated for Illinois, plotting the marker in the wrong state, like shown below.
Note: In the example below, Darien, Illinois, was not part of the data imported.

 
This issue occurs for ESRI maps in Report Services Documents, Visual Insight dashboards, Strategy Analytics Express, and Strategy Analytics Desktop.  
STEPS TO REPRODUCE:

• Create an Excel file with City and State data.
• Import the file into Strategy Web 9.4.1.
• Map the City attribute to the City Geo-role.
• Map the State attribute to the State Geo-role.
• Select the Map visualization.
• Place City in the Geo Attribute position. Latitude and Longitude values will be automatically populated.
• Place State in the tooltip. The resulting configuration would look as below: 
  

 
CAUSE:
This is a known issue in Strategy Web 9.4.1 and above. The city latitude and longitude is generated separately from the other columns in the excel file. When it finds a matching latitude and longitude for the city name, it moves on to the next row without verifying the data from other columns. 
ACTION:
Contact Strategy Technical Support for an update on the status of this issue.
WORKAROUND:
Provide the Latitude and Longitude information for each City to plot the markers in the correct places.

• Create a file with City, Latitude, and Longitude columns.
• Map each column to the proper Geo Role.
• Place Latitude in the Latitude position.
• Place Longitude in the Longitude position.
• Place City in the tooltip.
  

The marker displays correctly now:

KB47677