below.The ad hoc reporting tool (menu Back Office) is a flexible method to call up and compare important figures. There are different reporting areas:
1. Reservations
2. Forecasting
3. Guest profiles
4. Invoices
5. Event management (if SIHOT.C&B is serialised)
6. Event forecast (if SIHOT.C&B is serialised)
7. Services charged
8. Yield analyses (pick-up)
9. Sales potential
10. Maintenance status
11. Service tasks
12. Occupancy
13. Loyalty points
14. Loyalty rewards
To create an ad hoc report proceed as follows:
Ø Enter the search parameters, such as a date period, to outline your report in the tab Standard selection.
Ø Click search below.
SIHOT retrieves the requested data internally.
Ø Open the tab Search result.
Ø Select the fields to be analysed: tick the fields in the right hand pane or drag them into the panes Row Labels or Column Labels and values.
Ø Click on the arrow in the fieldname to specify the figures and/or sort them according to different aspects.
Ø Click on the button Excel export
to transfer the ad hoc report into
a spreadsheet.
TIP:
While creating the ad hoc reports,
SIHOT constantly adjusts the figures according to the selected fields. Depending
on the amount of data involved, this may slow down the process of customising
the report.
Tick the checkbox Defer Layout Update to be able to select
your rows, columns and values without the figures being updated at the same
time. Click Update to display the selected fields with the respective
figures.
Figure 51: Ad hoc reporting