PMI is a productivity management tool which looks at the productivity per department in the hotel. PMI calculates the productivity by looking at the cost driver (typically revenue, room nights or covers) for the department. PMI then takes the cost driver and divides...
source system
Manual Export S&C – Opera
Night Audit from Opera to PMI This report are used to import S&C OTB.. It has to be executed AFTER Opera Night Audit is successfully completed. Report: Daily Catering Forecast (rep_ev_forecast) 1. Go to Miscellaneous and choose Reports 2. Enter rep_ev in the...
Manual Export S&C – Delphi
Here are two SQL queries that can be used for Delphi S&C export. Both files are in Zipped format. File:Delphi Event.sql.zip File:Delphi OTB.sql.zip
Manual Export – Opera Scheduler
Report Scheduler: Schedule daily automatic run of the reports For certain release and license of Opera, a scheduling feature is possible to enable automatic execution at specified time(s). Below are the navigation steps.1. In Opera, select “PMS”2. In Opera PMS, select...
Data elements required from S&C
Why? The data set allows calculation of daily revenue forecast and optimal productivity as well as staffing level in PMI. What? The data set comprises of a daily snapshot of all sales and catering reservations recorded on the book for the next 365...
S&C – Delphi
The table below shows the data relationship between PMI data elements/fields (target) and corresponding source data elements/fields (source). You will find the transformation/load rules meant to explain any programmatic manipulation and calculation applied in the...
RMS – Easy RMS
The table below shows the data relationship between PMI data elements/fields (target) and corresponding source data elements/fields (source). You will find the transformation/load rules meant to explain any programmatic manipulation and calculation applied in the...
Data elements required from RMS
The table below shows the PMI data elements that need to be populated with values associated with corresponding data elements in the RMS application. There are two distinct sets of data needed from source RMS: RMS actuals and RMS reservations. Date range should be...
Data elements required for hotel market report
In GM daily digest PMI can display the competitor benchmarking KPIs such as ranking of the property in the comp set, RGI, MPI and ARI. To be able to do this PMI needs a daily import from the hotel’s provider of this data. Below is a description of what data is needed...
PMS – Protel
The table below shows the data relationship between PMI data elements/fields (target) and corresponding source data elements/fields (source). You will find the transformation/load rules meant to explain any programmatic manipulation and calculation applied in the...