2.1 Accommodation Daily Dataset


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 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 you are using AccommodationType Level bookings then this dataset 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

It represents actual accommodation or accommodation type.
Attribute form ID is prefixed by “A-“ for accommodation and “AT-“ in case of Accommodation type.
Accommodation-types are required for analysis of bookings at Accommodation-type.

Accommodation KindThis 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 indicates what type of accommodation it is. For example, "Accommodation", "Implied Accommodation" or "Accommodation Type"

Accommodation : it represents actual accommodation having Exclude availibility in BI is not checked.
Implied Accommodation : it represents actual accommodation having Exclude availibility in BI is checked.
Accommodation Type : it represents accommodation-type.

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

A calendar date is a reference to a particular day represented within a calendar system.

Calendar Date Day of WeekName of Calendar day e.g. Sunday, Monday etc.
Calendar Date ISO Week

The ISO week in which this date is classified e.g. any number from 1 to 53

Calendar Date ISO YearThe ISO year in which this date is classified e.g. 2019, 2020
Calendar Date MonthName of Calendar month e.g. January, February etc.
Calendar Date QuarterQuarter of Calendar year e.t. Q1, Q2 etc.
Calendar Date YearCalendar year e.g. 2019, 2020 etc.

Contract

ContractIt represents valid contract between owner and resort on particular calendar date and accommodation.
Contract Owner

It represents Contract type corresponding to valid contract.

Contract TypeIt 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:

Comparable Date: It is a date in the previous year having the same ISO week and the same day of week as of today's date.


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

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

Net turnover of the booked accommodation, meaning the gross price of the booked accommodation minus specials and included reservedresources.

ADR

Average Daily Rate is calculated from two other metrics: Accommodation Turnover / Occupied, i.e. the average price per night paid by customers for the accommodations that are actually occupied.

Available

Number of available accommodations per day including occupied accommodations. This takes into account if there is rentabiilty configured. 
If client use reservations at Accommodation Type level then it is always 0 at the level of grain (i.e. accommodation aka unit).

Occupancy

Occupancy is calculated from two other metrics: Occupied / Available.

If client use only Accommodation level reservations, then in that case following examples shows Available, Occupied and Occupancy on any particular calendar date

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

Apartment-A

appt-1

08-01-2019


0

1

0.00%

Accommodation

Apartment-A

appt-1

09-01-2019


0

1

0.00%

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 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.


If the client use Accommodation and Accommodation Type level reservations, then in that case following examples shows Available, Occupied and Occupancy on any particular calendar date

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%


Occupancy at level of Accommodation Type :

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 Provisional, Definitive, Checked-In or Checked-out.
Note that it does not include Cancelled reservation, to analyze them we have Reservation & Reservedresource cubes.

Preference bookingsNumber of occupied units that have been booked by a preference. Possible to calculate the preference booking percentage by: Preference bookings / Occupied

RevPAR

Revenue Per Available Room is calculated from two other metrics: Revenue / Available, i.e. the average price per night paid by customers for all the available accommodations.
Turnover BudgetTurnover budget per object per calendar date

Unit Days

The 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 a particular calendar date.

LY Last Week Turnover

It measures the revenue generated during the most recent ISO week of the previous year. This metric helps businesses compare their current ISO week's revenue to the same ISO week in the previous year.

LY Current Week Turnover

It measures the revenue generated during the current ISO week of the previous year. This metric helps businesses compare their revenue performance in the current ISO week of the current year to the same week of the previous year.

Next Week Comparable Turnover

It measures the revenue is expected to generate during the upcoming ISO week, compared to the same ISO week in the previous year.

Last Week Comparable Turnover

It measures the revenue generated during the most recent ISO week, compared to the same ISO week in the previous year.

CY Yesterdays Turnover

It measures the revenue generated during the most recent day of the current year. This metric helps businesses track their daily revenue performance and gain insights into their overall revenue generation.

LY Current Week Turnover

It measures the revenue generated during the current ISO week of the previous year. This metric helps businesses compare their revenue performance in the current ISO week of the current year to the same week of the previous year.

LY Todays Comparable Turnover

It measures the revenue generated on the same day of the year as today, but in the previous year. This metric helps businesses compare their revenue performance on a specific day in the current year to the same day in the previous year.

LY Yesterdays Comparable Turnover

It measures the revenue on the same day of the year as yesterday, but in the previous year. This metric helps businesses compare their revenue performance on a specific day in the current year to the same day in the previous year.

Todays Comparable Turnover

It measures the revenue generated on the same day of the week as today, but in the previous week. This metric helps businesses compare their revenue performance on a specific day in the current week to the same day in the previous week.

Tomorrows Comparable Turnover

It measures the revenue generated on the same day of the week as tomorrow, but in the previous week. This metric helps businesses compare their revenue performance on a specific day in the current week to the same day in the previous week.

Yesterdays Comparable Turnover

It measures the revenue generated by a company on the same day of the week as yesterday, but in the previous week. This metric helps businesses compare their revenue performance on a specific day in the current week to the same day in the previous week.

LY Last Week Turnover

It measures the revenue generated during the most recent ISO week of the previous year. This metric helps businesses compare their current ISO week's revenue to the same ISO week in the previous year.