On this page you will find all definitions of attributes and metrics in our three datasets. All datasets are divided in definitions for Attributes and for Metrics.
| Table of Contents | ||
|---|---|---|
|
Accommodation Daily Cube
Grain (Level of Detail) : This Cube can provides information at accommodation per calendar day
and Accommodation-type per calendar day (stay days), but only if a reservation is present at Accommodation-type level.
Refer following example:
...
Accommodation Level-5
...
Accommodation
...
Calendar Date
...
Reservation Id
...
Accommodation Type
...
Apartment-A
...
appt-1
...
01-01-2019
...
1234
...
Accommodation
...
Apartment-A
...
appt-1
...
02-01-2019
...
1234
...
Accommodation
...
Apartment-A
...
appt-1
...
03-01-2019
...
1234
...
Accommodation
...
Apartment-A
...
appt-1
...
04-01-2019
...
1234
...
Accommodation
...
Apartment-A
...
appt-1
...
05-01-2019
...
Accommodation
...
Apartment-A
...
appt-1
...
06-01-2019
...
Accommodation
...
Apartment-A
...
appt-1
...
07-01-2019
...
Accommodation
...
Apartment-A
...
Apartment-A
...
07-01-2019
...
6789
...
Accommodation Type
...
Apartment-A
...
appt-1
...
08-01-2019
...
Accommodation
...
Apartment-A
...
Apartment-A
...
08-01-2019
...
6789
...
Accommodation Type
...
Apartment-A
...
Apartment-A
...
08-01-2019
...
9876
...
Accommodation Type
...
Apartment-A
...
appt-1
...
09-01-2019
...
Accommodation
...
Apartment-A
...
Apartment-A
...
09-01-2019
...
6789
...
Accommodation Type
...
Apartment-A
...
Apartment-A
...
09-01-2019
...
9876
...
Accommodation Type
...
Apartment-A
...
appt-1
...
10-01-2019
...
Accommodation
Note: Reservation Id is not available in Microstrategy as an attribute in Accommodation Daily Cube. It is used in example in order to explain the concept.
...
Attribute
...
Accommodation
Within this header you will find 8 attributes to provide information about the accommodation on different levels of detail. This is based on the tree-structure in Maxxton Software
...
It represents actual accommodation or accommodation type.
Attribute form ID is prefixed by “U-“ for accommodation and “AT-“ in case of Accommodation type.
Accommodation-types are required for analysis of bookings at Accommodation-type.
...
e.g. If there are only 2 levels of accommodationtypes are configured in Maxxton Software, then values in 2nd level will be repeated for level 3,4 & 5.
...
This attribute has 2 attribute elements : “Accommodation” or “Accommodation Type”.
This dimension can be used to identify Metric values against reservations at accommodation level and accommodation type level.
...
Accommodation Group
| Accommodation Group Level 1 | Accommodation Groups are defined in the Maxxton Software. For example 'Family Homes' or 'Appartment'. 5 levels are defined, in which level 1 is the least detailed and level 5 is the most detailed. |
| Accommodation Group Level 2 | |
| Accommodation Group Level 3 | |
| Accommodation Group Level 4 | |
| Accommodation Group Level 5 |
...
Accommodation Status
| Accommodation Status | This attribute shows current status of an accommodation on particular calendar date. Attribute Elements: |
| Availability Status | This attribute shows current availability status of an accommodation on particular calendar date. Attribute Elements: Available, Not available. |
| Release Status | This attribute shows current release status of an accommodation on particular calendar date. Attribute Elements: |
...
Calendar Date
...
Contract
| Contract | It represents valid contract between owner and resort on particular calendar date and accommodation. |
| Contract Owner | It represents Contract type corresponding to valid contract. |
| Contract Type | It represents owner corresponding to valid contract. |
...
Location
...
It represents country of location
...
It represents Location hierarchy configured in Maxxton software.
...
YTD/LYTD Metrics:
...
Reservation Date
...
Stay Date
...
LYTD Same Year
...
Less than previous year's comparable date
...
All days of Previous Year
...
LYTD Next Year
...
Less than previous year's comparable date
...
All days of Current Year
...
YTD Same Year
...
Less than Today's date
...
All days of Current Year
...
YTD Next Year
...
Less than Today's date
...
All days of Next Year
...
Metric
...
LYTD Next Year Stay
...
LYTD Same Year Stay
The four metrics below are all related to reservations made from January 1st previous year until yesterday, for the entire previous year.
...
YTD Next Year Stay
The four metrics below are all related to reservations made from January 1st current year until yesterday, for the entire next year.
...
YTD Same Year Stay
The four metrics below are all related to reservations made from January 1st current year until yesterday, for the entire current year.
...
Accommodation Turnover
...
The base sum per unit per day, so excluding all extra services like tourist-tax, service fee etc.
MXT-3166
...
ADR
...
Available
...
Number of available units per day, not dependent if the unit is actually reserved or not (including temporary locks)
At the level of grain, it is 1 for particular calendar date if any of the following condition is true:
- Booking is made on accommodation (and not on accommodation-type) and status is Definitive or above
- If accommodation is locked temporarily
- Accommodation is reservable.
...
Occupancy
Occupancy is calculated out of two other metrics: Occupied / Available
Following examples shows Available, Occupied and Occupancy for reservations at accommodation type level:
...
Accommodation Type
...
Accommodation Level-5
...
Accommodation
...
Calendar Date
...
Reservation Id
...
Occupied
...
Available
...
Occupancy
...
Accommodation
...
Apartment-A
...
appt-1
...
01-01-2019
...
1234
...
1
...
1
...
100.00%
...
Accommodation
...
Apartment-A
...
appt-1
...
02-01-2019
...
1234
...
1
...
1
...
100.00%
...
Accommodation
...
Apartment-A
...
appt-1
...
03-01-2019
...
1234
...
1
...
1
...
100.00%
...
Accommodation
...
Apartment-A
...
appt-1
...
04-01-2019
...
1234
...
1
...
1
...
100.00%
...
Accommodation
...
Apartment-A
...
appt-1
...
05-01-2019
...
0
...
1
...
0.00%
...
Accommodation
...
Apartment-A
...
appt-1
...
06-01-2019
...
0
...
1
...
0.00%
...
Accommodation
...
Apartment-A
...
appt-1
...
07-01-2019
...
0
...
1
...
0.00%
...
Accommodation Type
...
Apartment-A
...
Apartment-A
...
07-01-2019
...
6789
...
1
...
0
...
Accommodation
...
Apartment-A
...
appt-1
...
08-01-2019
...
0
...
1
...
0.00%
...
Accommodation Type
...
Apartment-A
...
Apartment-A
...
08-01-2019
...
6789
...
1
...
0
...
Accommodation Type
...
Apartment-A
...
Apartment-A
...
08-01-2019
...
9876
...
1
...
0
...
Accommodation
...
Apartment-A
...
appt-1
...
09-01-2019
...
0
...
1
...
0.00%
...
Accommodation Type
...
Apartment-A
...
Apartment-A
...
09-01-2019
...
6789
...
1
...
0
...
Accommodation Type
...
Apartment-A
...
Apartment-A
...
09-01-2019
...
9876
...
1
...
0
...
Accommodation
...
Apartment-A
...
appt-1
...
10-01-2019
...
0
...
1
...
0.00%
Note: Reservation Id is not available in Microstrategy as an attribute in Accommodation Daily Cube. It is used in example in order to explain the concept.
Accommodation Level-5 | Calendar Date | Occupied | Available | Occupancy |
|---|---|---|---|---|
Apartment-A | 01-01-2019 | 1 | 1 | 100.00% |
Apartment-A | 02-01-2019 | 1 | 1 | 100.00% |
Apartment-A | 03-01-2019 | 1 | 1 | 100.00% |
Apartment-A | 04-01-2019 | 1 | 1 | 100.00% |
Apartment-A | 05-01-2019 | 0 | 1 | 0.00% |
Apartment-A | 06-01-2019 | 0 | 1 | 0.00% |
Apartment-A | 07-01-2019 | 1 | 1 | 100.00% |
Apartment-A | 08-01-2019 | 2 | 1 | 200.00% |
Apartment-A | 09-01-2019 | 2 | 1 | 200.00% |
Apartment-A | 10-01-2019 | 0 | 1 | 0.00% |
...
Occupied
...
Number of occupied units per day.
At the level of grain, Occupied is 1, if Reservation is made on accommodation/accommodation-type and status is Definitive or above
...
RevPAR
...
Unit Days
...
Number of total units per day, it includes Available, final locked and archived units.
At the level of grain, It is always 1 for accommodation and 0 for accommodation-type on particular calendar date.