|
|
|
Synchronize OBI Data Mart Utility
Select Utilities>Synchronize Utilities>Synchronize OBI Data Mart Utility to display the OBI & Datamart Synchronize Utility screen. Use this screen to populate data mart tables for the first time for Opera Business Intelligence (OBI) use, or to recalculate and update the data mart tables, ensuring they contain the latest data. Once the data marts are built, they are updated after the End of Day/Night Audit Procedure. (Data Marts are data repositories with summarized, or aggregated, data taken from Opera tables and grouped into specific categories. The data marts are a source for quick retrieval of data by OBI cubes for reports and display.)
The available OBI data mart synchronization processes are:
To run the synchronization process, provide the following information and select the OK button. When the process is complete, a message informs you "Synchronizing Complete."
Sync. Type. Select the synchronization process from the LOV. Each is explained below.
Property. This LOV appears when the OPP_MHOT Opera Property Management Multi- Property Base add-on license code or OPR<version number>ORS license code is active. Select the down arrow to select a property from the list of values.
Note: Only properties with the parameter setting OBI>POPULATE/ SYNC. Manager's Report set will display in the LOV. The POPULATE/ SYNC. Manager's Report parameter must be set for those properties that are part of a pure ORS system, where the PMS is not active at the property and for which the PMS is not uploading datamart messages (such as MyFidelio).
Begin Date. Enter the beginning date for the data that will be synchronized.
End Date. Enter the ending date to be covered by the synchronization action.
This procedure populates additional columns for access by OBI for all the reservation statistics created at the property. The data mart and cubes affected are:
Data mart - Reservation_stat_daily
Cubes - Reservation History (Daily and Monthly), Travel Agent, Company, Pace Cubes (Past Data only)
This procedure populates the Reservation Summary Log table for the property for the first time. Date fields are not required for this process. The data mart and cubes affected are:
Data mart - Reservation_summary_log
Cubes - Pace Cubes (Daily and Monthly)
This procedure populates historical data for past blocks. The data mart and cubes affected are:
Data mart - Allotment_stat_daily
Cubes - Allotment
This procedure populates a new obi_managers_report_fact table which is used to build the Managers Report. This data mart also contains central revenues.
Note: The Sync. Managers Report displays in the drop-down list in an ORS environment where at least one property has the active application parameter OBI>POPULATE/ SYNC. Manager's Report. (See POPULATE/SYNC MANAGERS REPORT.) The Property LOV will only display the properties with this application parameter active. The POPULATE/ SYNC. Manager's Report parameter must be set for those properties that are part of a pure ORS system, where PMS is not active at the property and for which the PMS is not uploading datamart messages (such as MyFidelio).
The data mart and cubes affected are:
Data mart - Rep_manager
Cubes - Daily Summary
