Previous Topic

Next Topic

OBI Subject Areas Overview

Note: This topic applies to OBIEE OPI_<version number> OBI Enterprise (Multiple Properties), or OPI_BUIP_<version number> OBI Standard (Single). When the OBIEE version is installed, Sales and Catering Analytics subject areas are included within the OBI subject areas. In the single-property version of OPI_BUIP_<version number> OBI Standard (Single), Sales and Catering Analytics subject areas are not included. For more information on Sales & Catering Analytics Subject Areas, refer to S&C Analytics Subject Areas.

Introduction

Opera Business Intelligence (OBI) provides a solution for analyzing problems by quickly and accurately gathering large volumes of OPERA data and processing it into multidimensional views. By accessing OBI>Answers, you select the type of data you want to view for analysis. The results are formatted and presented to you in charts and graphs, allowing you to drill down and view the data from many perspectives.

Note: For more information on the OBI User Interface, refer to OBI UI Overview. For more information on each Subject Area, select the Subject Area you interested in from the Table below.

Subject Areas

On the Answers Dashboard, OBI data cubes are listed on the right-hand side of the screen, identified as Subject Areas. Subject Areas not requiring cubes for reports are also displayed in OBIEE, such as S&C Analytics. These non-cube subject areas are processed directly from Opera tables using online transactional processing (OLTP).

obi_subject_areas_list_1_15_10

Subject Area Columns

The Subject Area columns, on the left-hand side of the screen, are a list of the type of data available for selection that will appear in your reports. The columns contain dimensions, hierarchies, attributes, facts, and filters to present a multidimensional model of your request. Columns indicate the columns of data that your request will return. Together with filters, they determine what your results will contain. To run a request, you need to specify at least one column.

obi_block_history_column_comparison

Dimensions

The Subject Area (i.e. Block History) contains data dimensions, which are the categories or descriptions of the type of data that will be processed for your report, such as Resort, Time, Block, Travel Agent, Company, Market, etc.

Time and Dates

The Time and Dates Dimension contain selections for specific periods of time, such as Year, Quarter, Month, Day. Additionally, with the Time and Date Dimensions you can select comparisons between these periods of time. For example, by selecting Month Comparison, you can select dates in one month with the same dates in another month.

Hierarchies

Within each Dimension are available attributes (or specific, more detailed types of data) of that Dimension arranged in a hierarchy. Hierarchies define the levels of how data at the bottom level roll up to the higher level. For example, in the Company Dimension the lowest attribute in the hierarchy is Company ID which rolls up to Company Name, which rolls up to the Company Country, on up to the Company Region, and up to All Companies. Your selections determine the hierarchy you want included in the results and how users can drill-down to the lowest level of detail.

Note: When a column is identified as a Fact (i.e. Non Revenue Facts), the data gathered is measurements and the list are not arranged in a hierarchy. See Facts below.

Facts

Fact columns contain measures, or numeric facts, and are not arranged in a hierarchy (data does not roll up to other data in the list). An example of the Fact Column is Local Revenue Facts. When opened, the list contains all the possible measurements for selection for your report (i.e. Food and Beverage Revenue, Last Year’s Food and Beverage Revenue, etc.).

Filters

Filters, along with columns, determine what your results will contain. Filters restrict the result set, such as filtering out or excluding certain data. For example, a filter may exclude all data for the current year and only include data from past years. (In the example of Block History, there are no available filters, however.)

OBI Subject Areas

Select the link to the Subject Area you are interested in learning more about, below.

  •  
  • BLOCK STATUS CHANGES
  • ROOM BLOCK
  •  
  • BUSINESS BLOCK SUMMARY
  •  
  •  
  •  
  •  
  • CATERING REVENUE
  •  
  •  
  •  

 

See Also