...
Table of Contents | ||
---|---|---|
|
Grain (Level of Detail) : This Important:
This dataset only includes reservations having accommodation or acco type booked with a reservations status equal to Provisional, Definitive, Checked-In or Checked-out.
Grain (level of detail):
This dataset can provide information at accommodation per calendar day.Refer 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 the example in order to explain the concept. Empty Reservation Id indicates that there is no reservation made on that object on a particular date.
Accommodation type level reservations:
If clients you are using AccommodationType Level bookings then this dataset provide provide information at the level of:
Accommodation per calendar day
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.
Definitions:
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 |
|
...
Reservation Date | Stay Date | |
LYTD Same Year | All dates before the comparable date | All days of Previous Year |
LYTD Next Year | All dates before the comparable date | All days of Current Year |
YTD Same Year | All dates before Today's date | All days of Current Year |
YTD Next Year | All dates before Today's date | All days of Next Year |
...