...
Grain (Level of Detail) : This Cube dataset can provides information at accommodation provide information at accommodation per calendar day.
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 | appt-1 | 08-01-2019 | Accommodation | |
Apartment-A | appt-1 | 09-01-2019 | Accommodation | |
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. Empty Reservation Id indicates that there is no reservation made on that object on particular date.
If clients are using AccommodationType Level bookings then this dataset provide information at the level of :
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. Empty Reservation Id indicates that there is no reservation made on that object on particular date.
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 Group |
| ||||||||||||||
Accommodation Status |
| ||||||||||||||
Calendar Date |
| ||||||||||||||
Contract |
| ||||||||||||||
Location |
|
YTD/LYTD Metrics:
Comparable Date : It is date in previous year having same ISO week and same day of week as of today's date.
Reservation Date | Stay Date | |
LYTD Same Year | Less than previous year's All dates before comparable date | All days of Previous Year |
LYTD Next Year | Less than previous year's All dates before comparable date | All days of Current Year |
YTD Same Year | Less than All dates before Today's date | All days of Current Year |
YTD Next Year | Less than TodayAll dates before 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 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.
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 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.
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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:
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Occupancy | Occupancy is calculated out of two other metrics: Occupied / Available Following examples shows Available, Occupied and Occupancy for reservations at accommodation type level:
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.
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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. |
...