BI - BLOCK HISTORY 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 subject areas, see S&C Advanced Reporting Subject Areas.

BI - Block History

This Subject Area (BI - Block History) contains daily rooms and revenue information on Blocks summarized by Resort, Block Code, Travel Agent, Company, Market, Room Type, and Source. The BI - Block History Subject Area is accessed through OBI>Answers.

BI - Block History Columns

When the BI - Block History 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_answers_block_history_columns

ALLOT_STAT_BI Cube

To prepare for data collection for the BI - Block History Subject Area, set up and activate the ALLOT_STAT_BI Cube in Opera. Access Configuration>Setup>Opera Business Intelligence Setup>ALLOT_STAT_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.