Format for a Hotel Sales Report Daily by xhg29090

VIEWS: 2,889 PAGES: 4

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

								
To top