AccommodationDaily-Dimensions

 

Cognos Powerplay 

MicroStrategy

Alternative 

Dimensions

Cube name

Attribute

 

  Accommodation

Accommodation Daily

Accommodation, Accommodation Level 1-5

 

  Date

Accommodation Daily

Calendar Date

 

  Date: Standard Changeover

N/A

N/A

 

  Date: Week of Year (ISO)

Accommodation Daily

Calendar Date ISO Week

 

  Date: Day of Week

Accommodation Daily

Calendar Date Day Of Week

 

  Date: Month

Accommodation Daily

Calendar Date Month

 

  Accommodation: Kind

Accommodation Daily

Accommodation Kind

 

  Accommodation: CBS code

N/A

N/A

 

  Accommodation: Status

Accommodation Daily

Accommodation Status

 

  Accommodation: Availability

Accommodation Daily

Availability Status

 

  Accommodation: Contract Type

Accommodation Daily

Contract , Contract Type

 

  Reservation: Date

Accommodation Daily

Reservation Date

 

  Reservation: Current weeks (ISO)

N/A

N/A

 

  Reservation: Current days (ISO)

N/A

N/A

 

  Reservation: Year (ISO)

Accommodation Daily

Reservation Date ISO Year

 

  Reservation: Week of Year (ISO)

Accommodation Daily

Reservation Date ISO  Week

 

  Reservation: Day of Year (ISO)

N/A

N/A

 

  Reservation: Day of Week

Accommodation Daily

Reservation Date Day Of Week

 

  Reservation: Month

Accommodation Daily

Reservation Date Month

 

  Reservation: Lag

Accommodation Daily

Reservation Lag ,Reservation Lag Interval 30 Days/5 Days/7 Days

 

  Reservation: Status

Accommodation Daily

Reservation Status

 

  Reservation: Lodging Period Type

Accommodation Daily

Reservation Duration , Reservation Duration Interval 30 Days / 5 Days/7 Days

 

  Reservation: Category

Accommodation Daily

Reservation Category

 

  Reservation: Distribution Channel

Accommodation Daily

Distribution Channel Level 1  - 5

 

  Reservation: Arrival date

Accommodation Daily

Start Date

 

  Reservation: Powerplaygroup

Accommodation Daily

Accommodation Group Level 1 - 5

 

  Reservation: Family Composition

N/A

N/A

 

  Reservation: Source

N/A

N/A

 

  Customer: Country

Reservation

N/A

 

  Customer: Retention

Reservation

Loyal Customers

 

  Employee

Reservation

N/A

 Employee