previous

BI - Stay 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 - Stay

This Subject Area (BI - Stay) contains statistical information based on stay records analyzed by Resort, Guest, Company, Market, Rate, Revenue Type, Room Type, Rate Code and Insert Source. The BI - Stay Subject Area is accessed through OBI>Answers.

BI - Stay Columns

When the BI - Stay 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_subject_areas_stay

The BI - Stay columns, dimensions, and facts available for the STAY reports are listed here in a .pdf file. Click here.

STAY_BI Cube

To prepare for data collection for the BI - Stay Subject Area, set up and activate the STAY_BI Cube in Opera. Access Configuration>Setup>Opera Business Intelligence Setup>STAY_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_setup_stay_aw

See Also