BI - Turnaway Subject Area

Note: This topic applies to OBI having licenses OPB_<version number> OBI Enterprise (OBIEE - Multiple Properties), or OPI_BUIP_<version number> OBI Standard (Single) using OLAP technology and data cubes. This topic does not apply to standalone S&C Advanced Reporting whose data is accessed directly from Opera tables via OLTP. For S&C Advanced Reporting, see S&C Advanced Reporting Subject Areas or S&C Advanced Reporting Setup.

BI - Turnaway

The BI - Turnaway Subject Area is accessed through OBI>Answers. This Subject Area allows users to analyze and address rejection and lost business patterns. With the BI - Turnaway Cube, you can:

Run reports on Turnaways by Resort, Time (date/date range), Market Code, Turnaway Code, and Employee.
Compare the volume of Turnaways by Resort, Market, Employee/User and Rate Code between different time periods.
Measure the number of room nights as well as the revenue affected by the Turnaways based on the selections made during the reservation process.
Analyze the causes of the Turnaways and make a more informed decision to address them.
Note: During the introduction of the TURNAWAY Cube (v5.0.03.01), only Turnaways from the Central System will be reported, as Turnaways are not currently transferred from PMS to ORS.

BI - Turnaway Columns

When the BI - Turnaway Subject Area is selected, the following columns are available to build reports in OBI.

Note: In OBIEE OPB_<version number> OBI Enterprise (Multiple Properties), when users hover the mouse cursor over any attribute or measure of a Subject Area, a tooltip displays that describes the column. If applicable, a description of how the values are calculated is also included.

obi_turnaway_answers_columns

TURN_BI Cube

To prepare for data collection for the BI - Turnaway Subject Area, set up and activate the TURN_BI Cube in Opera. Access Configuration>Setup>Opera Business Intelligence Setup>TURN_BI. Other tables in Opera are combined to build the subject area requests and reports. For more information on cube setup and maintenance, see the online help topics: OBI Setup and OBI Cube Maintenance.

obi_turn_cube_setup