You are viewing an old version of this page. View the current version.
Compare with Current
View Page History
« Previous
Version 4
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 from January 1st previous year until yesterday, for the entire current year.
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 from January 1st previous year until yesterday, for the entire previous year. 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 from January 1st current year until yesterday, for the entire next year. 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 from January 1st current year until yesterday, for the entire current year. 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. |