Get documents about "Format for a Hotel Sales Report Daily
Description
Format for a Hotel Sales Report Daily document sample
Document Sample
Sorting
Click the box of the column without clicking the title (the cell
will highlight blue) and then click the triangle icon above the
column title to sort
Swap Rows and Columns
Use this button to swap the rows and columns of the table layout.
Hotel
Suppress Zeros
Use this button to suppress all rows and/or columns of zeros from Online Analysis and Reporting
displaying on your report
Graphing
You have the ability to see pie charts, simple bar, clustered
bar, stacked bar, 3-D bar, and multi-line graphs. To change from
data graphs, click the bar chart button at the bottom of the screen
or select the popout menu button and your selected graph.
Saving / Publishing /
To save a report, follow these steps:
Click this Save As icon at the bottom tool bar.
Type a name for the report. You can also type a description
(optional).
Select the Location; My Folder or Travelocity Shared Views Folder
Click Finish.
Exporting a Report
Reports or charts may be saved as .pdf (Adobe Acrobat
format) , .csv files, or Excel files.
Tip: Make sure to set the number of viewable rows ALL before
exporting otherwise you will only get partial report when you
export it.
Travelocity Reports: Cognos 8.2
Please contact your Travelocity Global Accounts Manager.
Quick Reference Guide for HotelVision
Filtering
Logging On You can filter or change information you want to view
Open browser
Use link below Click any of the Dimensions at the top to filter. If you see a triangle to the right of the
https://hotelvision.sabre.com/c8/ drop down menu, you may further filter by hovering over this triangle and a submenu
Enter your user ID/password and click OK will appear
button. Contact your Account Manager for
ID & password. Drilling
You may drill down or up to analyze your business.
Folders and Cubes Bring up the navigation menu by left-clicking in the
column separation bar (circled in red). You can drill-
HotelVision Data Analysis folder–
down by clicking the button circled in blue. Likewise,
Cubes & reports with bookings by drill-up by clicking the button circled in green.
both book date & check-in date. Expand the column (nesting the next level of detail)
HotelVision Email Reports folder– by clicking the button circled in orange.
Weekly and monthly reports at
Company, Chain, and Property level. Nesting is done by dragging the desired element
Hotel Booking Performance cube– from the index view on the left over the right edge of
Main internal cube with booking data. the column to nest until the thin blue rectangle
TVL Competitive Pricing cube – appears (circled in red). The same
Pricing data process can be applied to row
replacement.
Basic Navigation and Settings Changing Dimensions
Application is browser-based so you can use Replacing a dimension with another dimension can be
Back, Forward, and other browser buttons. accomplished by dragging the desired replacement
The Display Options sub-window is accessed dimension over the column or row headers that you
via the Display Options button shown at right want to replace. When the column or row being
Viewable rows and columns can be set from replaced highlights blue then
the Display Options sub-window as well as the desired Display Measure release the mouse.
Click this icon to reset all dimensions to highest level
Click the single inverted triangle button to move one page Change Measures
down or right A measure is a quantifiable amount, such as booking,
Click the stacked triangle button to go to the bottom or far right of the report revenue, room night, average daily rate, room utilization, etc.
Note: The triangle/nav buttons appear if you have more columns / rows than specified Use the Measure dimension drop down menu at the top left
to change the measure used in a report.
Dimension Line
The dimension
Show Percentages
line shows how your viewable You may show the measure as values or as
data is being filtered percentages. Right-click in the upper left-hand cell
and choose how you want the values displayed from
For a visual map of where you the menu.
are in the data, click the
dimension line “buttons”. The Password Resets
dimension menu appears. Please email COGNOS SUPPORT in order to get your password reset.
Cubes Dimension Definitions – continued…
Hotel Booking Performance (HBP) – This is the combined check in and book date 9. Distribution Type – (TVL) Allocation, TVL DC, or (TN) GDS
cube. This cube will be used to track the data at a more Company and Chain level. 10. Inventory - The rate type used for the booking: Last Minute, Package, Room
Location: Public Folders/HotelVision Data Analysis/Hotel Booking Performance Only Net, Room Only Published.
Supplier HBP Cubes’ Location: Public Folders/HotelVision Data Analysis/Hotel 11. Booking Path – This shows which booking path the booking was made through
Booking Performance by Supplier 12. Booking State – This states if the booking is cancelled or not.
13. Online/Offline – This will tell if the dimension is Online or Phone (Offline)
TVL Regional Cubes – These seven cubes are to be used more for Travelocity Market 14. Advance Purchase Bucket – The number of days the booking was made before
check-in
managers in order to get down to the property level.
15. LOS Bucket – The number of days staying after check-in
Location: Public Folders/HotelVision Data Analysis/PM Regions folder
16. Saturday Night Stay – This tells if the booking includes a Saturday stay.
TVL Competitive Pricing Cube – This is the cube which houses all the shopping data in TVL Price Competitive
order to analysis the price/availability of your hotels vs the competitors. 1. Shop Date – The date the shop occurred
Location: Public Folders/TVLG/Competitive Pricing 2. Origin Region – This is the airport from where the search starts from
3. Destination Region – This is the destination airport from the search
Company Compset Cubes – There are several cubes representing the different 4. Source Site – The internal websites which are shopped
companies which have access to this data. It allows the company to compare themselves 5. Comparison Site – The external websites which are shopped
against their competitors. 6. Source Product Type – This is the different combination of products. Flight and
Location: Public Folders/HotelVision Data Analysis/Company Compset – Hotel, and Hotel.
[Company Name] 7. Comparison Product Type – This is the different combination of products.
Flight and Hotel, and Hotel.
Chain Compset Cubes - There are several cubes representing the different chains which 8. LOS – Length of Stay
have access to this data. It allows the chain to compare themselves against their competitors. 9. AP – Advance Purchase Window
Location: Public Folders/HotelVision Data Analysis/Chain(1-8) Compset 10. Number of Persons
11. Fare Type-Bulk and Pub
12. Shop Group – This is the method of shopping which was used. CDS is
Travelocity Property Compset Cube – This cube allows you to be able to view how a
consumer driven shops; SSH is forced shopping.
property is doing against its competitors.
13. Shop Type- This is the type of shop: cheapest shop option or exact flight match
Location: Public Folders/HotelVision Data Analysis/Travelocity Property
14. Hotel Rate Type – This tells if it is Hotel or Package Rate.
Compset
15. LOB and Supplier – This is the lines of business and the companies under each.
Passive Cube – This cube identifies which agencies are booking passive bookings (outside
of Sabre) and provides Marketing opportunities to contact those agencies and encourage them
to book more through Sabre.
Location: Public Folders/HotelVision Data Analysis/Passive
Archived Email Reports – This is the location that you are able to retrieve old Company
and Chain Monthly/Weekly Reports.
Location: Public Folders/Hotel Vision Email Reports
Dimension Definitions
Hotel Booking Performance
1. Hotel Supplier- Company, Chain, Property
2. Checkin Date – Date checking in
3. Book Date – Date the customer made the reservation
4. Ski Region – The regions set up for Ski Destinations
5. Management Company – A type of company that manages different supplier’s
properties
6. Agency Location – Location of the agency that created the booking
7. Destination – Location of the airport destination
8. Distribution Channel – The channel which the booking was made:
Travelocity, Sabre Travel Network, or Corporate Solutions
Measures Examples:
Hotel Booking Performance Market Manager View – Location: Public Folders/Travelocity Shared
1. Booking Views/Reporting Folder/Pricing Folder
2. Room Nights
3. Hotel Sales
4. ADR
5. SALES Per Booking
6. AVG LOS
7. Avg Advance Booking
TVL Price Competitive
1. Shopped Records – Total Shopped Records
2. Source Site Rate Amt – Base Travelocity Price excluding fees
3. Competitor Rate Amt – Base Competitor Price excluding fees
4. Source Site Markup % - Package Effective Markup over Base Rate %
5. Source Site Markup Amt - Package Effective Markup amount * Base Rate Insert Supplier
6. Source Site Base Cost Amt - Package Cost (Base Rate – Markup) Insert Comparison Site Filter Source site
Chain as row by Travelocity
7. Competitor Markup Amount - based on Competitor Base Price and as column
and Product by
Travelocity Cost
HTL
8. Competitor Markup % - Markup as a % of Competitor Base Price Nest Measures in the And Destination by
9. PWR – Price Win Ratio is the % of time PCI is above .99 columns Market Manager
10. PLR – Price Loss Ratio is the % of time PCI is below 1.01
11. PCI – Price Competitive Index
12. PTR – Price Tie Ratio is the % of time the PCI is between .99 and 1.01
PLR & PWR Conditional Formatting Rules PCI Conditional Formatting Rules
13. Source Average Daily Rate - Base Rate divided by Guests and Length of Stay
14. Competitor Average Daily Rate - Base Rate divided by Guests and Length of
Stay
15. PLR (Total Rate) - Loss Rate on Total Price, includes fees
16. PWR (Total Rate) - Win Rate on Total Price, includes fees
These are the rules that I have applied to each of these columns and the
corresponding colors
TIPS AND TRICKS
1. Always create your view with all your dimensions laid out like you
would like to see before going down to the property level.
2. In order to get down to the property level in the Pricing cube, you
will need to NEST the Supplier Dimension inside of the Market
Manager Dimension then you will need EXCLUDE Zeros.
3. Try to always put the longer list of values as rows rather than
columns. It is always easier to scroll down.
4. Remember to filter DISTRIBUTION CHANNEL by
TRAVELOCITY if you are interested in just Travelocity data.
5. If Cognos gives you an error, always try and refresh the screen.
Then if you need further assistance, email Cognos Support.
6. The Price Competitive cube has data for the past 45 days and
Report date is the date the website was shopped.
Related docs
Other docs by xhg29090
