Versions Compared

Old Version 25

changes.mady.by.user Roelant de Looff

Saved on

compared with

New Version 26

changes.mady.by.user Abdul Qayyum Gadbade

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

Number 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 TurnoverIt 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 TurnoverIt 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 TurnoverIt 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 TurnoverIt measures the revenue generated during the most recent ISO week, compared to the same ISO week in the previous year.
CY Yesterdays TurnoverIt 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 TurnoverIt 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 TurnoverIt 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 TurnoverIt 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 TurnoverIt 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 TurnoverIt 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 TurnoverIt 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 TurnoverIt 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.