KB45824: The attribute forms "Latitude" and "Longtitude" cannot be displayed for some prefectures in a report in MicroStrategy Web

SYMPTOM:
 
If users import a list of prefectures and convert it to a report, the attribute forms "Latitude" and "Longtitude" cannot be displayed for some prefectures in Strategy Web 9.4.1.
 
STEPS TO REPRODUCE:

• Import an excel file which contains prefectures, such as "MIYAGI-KEN", via Strategy Web 9.4.1.
• In the data importing preview, change the geography role to "State -> Country" for the attributes.
• Save it as an Intelligent Cube.
• Create a report based on the Intelligent Cube.
• Display the attribute forms "Latitude" and "Longtitude" for the attribute En Name.
• While most of cities show the corresponding "Latitude" and "Longtitude" values, some, such as "MIYAGI-KEN", don't show the "Latitude" and "Longtitude" values.
   
  

CAUSE:
 
The scenario is caused by the missing data in Country.csv, State.csv, City.csv or ZipCode.csv under the path C:\Program Files (x86)\MicroStrategy\Intelligence Server.
 
ACTION:
 
Users can update the corresponding CSV files (Country.csv, State.csv, City.csv, ZipCode.csv) under path C:\Program Files (x86)\MicroStrategy\Intelligence Server to solve the problem. Take State.csv  and State “Tokyo” for example, if users want to have derived Attribute of Country of the State and the corresponding latitude/longitude, users can add Japanese prefectural capital in the SubdivisionStateAlternateNames columns.
 
Below are the detailed steps:

• Open the State.csv file.
   
  

• Search for "Tokyo" in the "SubdivisionStateName"  column.
• Then add the Japanese name "東京都" at the end of the corresponding AlternateName column, separating by comma:
   
  

• Same operations can be done on the other States and then save the CSV file.
   
  Note that users need to save the csv file with Unicode encoding.
• Restart the Intelligence Server and import the excel file again. The derived Attribute and the latitude/longitude can be displayed in the report as expected.
   
  

If the Latitude and Longtitude are missing for a prefecture, such as "Miyagi-ken", users can add one row entry manually following the formatting in the file.