You are viewing an old version of this page. View the current version.
Compare with Current
View Page History
« Previous
Version 5
Next »
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 | Definition |
---|
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 Accommodation | 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. | Accommodation Kind | This indicates what kind of accommodation it is. For example a villa, camping place, beach lodge or a chalet. | Accommodation Level 1 | It shows level of Accommodation type in hierarchy configured in Maxxton Software under Location. Level 1 is the highest level while level 5 is the lowest level in hierarchy.
If less than 5 levels are configured in Maxxton Software, then for the remaining levels value from lowest level will be repeated. 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.
| Accommodation Level 2 | Accommodation Level 3 | Accommodation Level 4 | Accommodation Level 5 | Accommodation Type | 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: Locked temporary, Locked phasing, Archived, Occupied, Free, Implied | Availability Status | This attribute shows current availability status of an accommodation on particular calendar date. Attribute Elements: Available, Not available. Availability status us “Available” when it’s Accommodation Status is Free, Locked temporary or Occupied Availability status us “Not Available” when it’s Accommodation Status is Implied, Locked phasing, Archived | Release Status | This attribute shows current release status of an accommodation on particular calendar date. Attribute Elements: Open for testing, Open for owners, Open for all, Closed |
|
Calendar Date | Calendar Date |
| Calendar Day of Week |
| Calendar ISO Week |
| Calendar ISO Year |
| Calendar Month |
| Calendar Quarter |
| Calendar Year |
|
|
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 | Location Country | It represents country of location | Location Level 1 |
It represents Location hierarchy configured in Maxxton software.
| Location Level 2 | Location Level 3 | Location Level 4 | Location Level 5 |
|
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 | Definition |
---|
LYTD Next Year Stay | The four metrics below are all related to reservations made before today's date of previous year, for the entire current year. These four metrics can be compared to YTD Next Year Stay.
LYTD ADR Next Year Stay | LYTD Occupany Next Year Stay | LYTD RevPAR Next Year Stay | LYTD Turnover Next Year Stay |
|
LYTD Same Year Stay | The four metrics below are all related to reservations made before today's date of previous year, for the entire previous year. These four metrics can be compared to YTD Same Year Stay. LYTD ADR Same Year Stay | LYTD Occupany Same Year Stay | LYTD RevPAR Same Year Stay | LYTD Turnover Same Year Stay |
|
YTD Next Year Stay | The four metrics below are all related to reservations made before today's date, for the entire next year. These four metrics can be compared to LYTD Next Year Stay. YTD ADR Next Year Stay | YTD Occupany Next Year Stay | YTD RevPAR Next Year Stay | YTD Turnover Next Year Stay |
|
YTD Same Year Stay | The four metrics below are all related to reservations made before today's date, for the entire current year. These four metrics can be compared to LYTD Same Year Stay. YTD ADR Same Year Stay | YTD Occupany Same Year Stay | YTD RevPAR Same Year Stay | YTD Turnover Same Year Stay |
|
Accommodation Turnover | The base sum per unit per day, so excluding all extra services like tourist-tax, service fee etc. MXT-3166 |
ADR | Average Daily Rate, calculated out of two other metrics: Accommodation Turnover / Occupied. This is the average price per night paid by customers for the units that are actually occupied. |
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 | Revenue Per Available Room, calculated out of two other metrics: Accommodation Turnover / Available. This is the average price per night paid by customers for all the available units. |
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. |