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.
Pages to are hidden for
"Format for a Hotel Sales Report Daily"Please download to view full document