KB211990: World Countries and United States alternative names for the Image Layout Widget in MicroStrategy Web 9.4.1

• Strategy

Summary

Strategy Web 9.4.1 supports the use of the Image Layout Widget to plot polygons corresponding to data defined in HTML coordinates files. It is a requirement for the grid data to match the coordinates file entries exactly for the shapes to be plotted correctly. However, for simplicity purposes several country and state alternative names have been related to their corresponding out of the box coordinates files. These alternative names will be plotted just as if the correct name was included. The Image Layout widget will try to find the grid data and the shape file name in the alias table, if both are found in the same line then they will be considered as equal. The alias information is shown below.

Countries of the World aliases

This list of country aliases are only used for the following two out of the box shape files:

Countries of the World
Countries of Europe

The table is in the following format:

R01_Y1999_SALES R01_Y2000_SALES R02_Y1999_SALES R02_Y2000_SALES YEAR_IDMONTH_IDREGION_IDSTORE_IDSALES_AMT19991999011000150199919990110002200MONTH_IDSTORE_IDSALES_AMT1999010001501999010002200
CLIENTMACHINE

COUNT(*)

Server Machine: 23.4.3.146 Client Machine:

8
CLIENTMACHINEEVENTSOURCECOUNT(*)Server Machine: 11.30.17.243 Client Machine:264Server Machine: 11.30.17.243 Client Machine:132 Denodo 5.0 Strategy ODBC Drive for PostgreSQL Wire ProtocolCertifiedCountry Alias EntryUnited States,United States of America,Vereinigte Staaten von Amerika,États-Unis,Estados Unidos,US,USAUnited Kingdom,United Kingdom,GroÃƒÂŸbritannien,Royaume-Uni,Reino Unido,GB,GBRState Alias EntryAL,AlabamaAk,Alaska

The complete list is appended to this document with the name: Country.xls
Alternative Names are separated by commas. Notice that some Countries in this table are not in the shape files, however, they can be manually added into the file following the logic mentioned in the summary.

States aliases for the United States of America

This list of state aliases consists of the United State abbreviation and will only be used in the following out of the box shape files:

States of USA
State Markers of USA

The table is in the following format:

The complete list is appended to this document with the name: State.xls

Note: These alternative names will work in Strategy Web and Mobile 9.4.1 and later.

Comment

0 comments

Details

Knowledge Article

Published:

April 13, 2017

Last Updated:

July 17, 2017