iMIS Analytics is shipped with the USA set as the default country for any address with a blank country field. The default country is set in the DWSCountryRef table in the Alias field containing a ‘,’.

To change the default country, update the following on the DWSCountryRef table through a SQL browser:

1) Update the record for US and remove the comma field from the Alias Field. The field will be changed from

“,United States of America,U.S.A.” to just “United States of America,U.S.A”

2) Next update the record for the country that will be the default country by adding a ‘,’ to that country’s Alias field.

3) Rebuild the cubes to see the changes.