Countries

The “Countries” cube contains information about the countries that are supported by X-Assist.

“Countries” is a Type 2 SCD that allows change tracking over time by applying a filter to “Countries – Valid on” or selecting it as a time dimension.

Measures

Count

The number of distinct countries in the result set.

Dimensions

Name

The name of the country.

For data exports, the ISO 3166-1 alpha-2 country code is used instead.

Overall country risk

The overall risk rating of the country.

This value is only meaningful when „Countries – Valid on“ is selected as a filter or time dimension.

Possible values:

• Low (1): The overall country risk is low.

• Elevated (2): The overall country risk is elevated.

• High (3): The overall country risk is high.

• Extreme (4): The overall country risk is extreme.

• Unknown (5): The country has not been rated yet.

Country security risk

The security risk rating of the country.

See Overall country risk for the list of possible values.

Country medical risk

The medical risk rating of the country.

See Overall country risk for the list of possible values.

Terrorism / Armed Conflict

The terrorism / armed conflict risk rating of the country.

See Overall country risk for the list of possible values.

Civil Unrest

The civil unrest risk rating of the country.

See Overall country risk for the list of possible values.

Crime

The crime risk rating of the country.

See Overall country risk for the list of possible values.

General Risks

The general risks rating of the country.

See Overall country risk for the list of possible values.

Governance

The governance risk rating of the country.

See Overall country risk for the list of possible values.

Valid on

The UTC period during which the record was valid (i.e. the time from creation to deletion of the record).

Join compatibility

Countries can be joined with:

• Bookings

• Country stays

• Events