People
The “People” cube contains information about the people that X-Assist knows about. This includes travellers, expats and regular users.
The following Venn diagram shows the logical relation between the sets of people, travellers, expats and users:
“People” is a Type 2 SCD that allows change tracking over time by applying a filter to “People – Valid on” or selecting it as a time dimension.
Measures
Count
The number of distinct people in the result set.
Dimensions
ID
The unique identifier of the person in X-Assist.
First name
The person's first/given name. This value is optional.
Last name
The person's last name/surname. This value is optional.
Email
The person's email address. This value is optional.
Phone
The person's phone number. This value is optional.
Has full contact information
A flag that indicates if the person has a name, email address and phone number.
Is user
A flag that indicates if the person has a user account in X-Assist.
Possible values:
True (
true): The person has a user account in X-Assist.False (
false): The person does not have a user account in X-Assist.
Has app
A flag that indicates if the person has activated the X-Assist app on at least one mobile device.
Possible values:
True (
true): The person is logged into the X-Assist app on at least one mobile device.False (
false): The person is not logged into the X-Assist app on any mobile device.
Join compatibility
People can be joined with:
Last updated
