Oracle Business Intelligence Suite Enterprise Edition

Oracle Business Intelligence Suite Enterprise Edition

Developer(s)	Oracle Corporation
Stable release	11.1.1.3 / August 13, 2010; 13 months ago (2010-08-13)
Written in	C++, Java
Operating system	Windows, Linux, Solaris, HPUX, AIX, MACOSX
Available in	Multiple (English, Japanese, etc.)
Type	Business Analytics
License	Proprietary
Website	http://www.oracle.com/us/solutions/ent-performance-bi/enterprise-edition-066546.html

Oracle Business Intelligence Enterprise Edition Plus, also known as OBI EE Plus, is Oracle's set of business intelligence tools consisting of former Siebel business intelligence and Hyperion business intelligence offerings.

The industry counter-part and main competitors of OBIEE are Microsoft BI, IBM Cognos, SAP Business Objects and SAS. The products currently leverage a common BI Server providing integration among the tools.

Overview

Oracle Business Intelligence Foundation Suite (OBIEE+ and Essbase) is a complete, open, and architecturally unified business intelligence solution for the enterprise that delivers capabilities for reporting, ad hoc query and analysis, OLAP, dashboards, and scorecards. All enterprise data sources, as well as metrics, calculations, definitions, and hierarchies are managed in a Common Enterprise Information Model, providing users with accurate and consistent insight, regardless of where the information is consumed. Users can access and interact with information in multiple ways, including web-based interactive dashboards, collaboration workspaces, search bars, ERP and CRM applications, mobile devices, and Microsoft Office applications.

Sometimes OBIEE is used interchangeably with Oracle Business Intelligence Applications (OBIA), which is a pre-built BI and data warehousing solution built on the OBIEE technology stack. The OBI EE Plus integrates the components of the toolset to include a service-oriented architecture, data access services, an analytic and calculation infrastructure, metadata management services, a semantic business model, a security model and user preferences, and administration tools.

Components

Oracle BI server

an analysis server providing a calculation and aggregation engine that integrates data from multiple relational, unstructured, OLAP, and other sources.

Oracle BI Admin Tool

an administrator tool used to construct repositories consisting of a Physical Layer, Business Model and Mapping Layer, and an abstracted end-user Presentation Layer subsequently visible in BI Answers.

Oracle BI Answers

an ad-hoc query and analysis tool that processes the data from multiple data sources in a pure web environment. Users are isolated from data structure complexity and they view and work with a logical view of the information. Users can create interactive charts, pivot tables, reports, and dashboards. Analysis can be saved, shared, modified, formatted, or integrated in the user's dashboards.

Oracle BI Marketing

caters to marketing needs, known as Segmentation Server.

Oracle BI Interactive Dashboards

interactive web architecture dashboards that display required information to help users' decision making. Access to the information is interactive, based on the individual's role and identity. The end user works with live reports, charts, tables, prompts, pivot tables, and graphics and has full capability for modifying and interacting with results. Dashboards can aggregate content from other sources (e.g. the Internet, shared file servers, and document repositories).

Oracle BI Delivers

an alerting tool that provides monitoring of business activity. They are reached via multiple channels including email, dashboards, and mobile devices. It includes a web-based self-service portal where users can create and subscribe to alerts. Dashboard can initiate and pass contextual information to other alerts to execute multi-step, multi-person, and multi-application analytical workflow. It can determine recipients and personalize content to 'reach the right users at the right time with the right information'.

Oracle BI Disconnected Analytics

offers BI Answers and Dashboards to mobile professionals on computers disconnected from the network. It provides the same interface for users whether they are working in connected or disconnected mode.

Oracle BI Publisher

a reporting engine capable of generating reports from multiple data sources in multiple formats via multiple channels.

Oracle BI Briefing Books

reports captured series of snapshots of Oracle BI Dashboards.

Oracle BI Office Plug-In

automatically synchronizes information from BI Answers to Microsoft Word, Microsoft Excel, and Microsoft PowerPoint.

Oracle Hyperion Financial Reporting

creates book quality financial reports in a variety of formats (including XBRL) and supports a variety of sources including Oracle's Hyperion performance management applications (EPM) and Oracle Essbase.

Hyperion Interactive Reporting

pulls data together from operational or analytic sources to create charts, privots, and reports and can access the Oracle BI Server semantic layer.

Hyperion SQR Production Reporting

provides cross functional reporting from a variety of relational databases and data sources.

Hyperion Web Analysis

delivers out-of-the-box presentation and reporting for Oracle [[Essbase]] and other multi-dimensional sources.

Extensions

• Oracle Scorecard: an implementation of balanced-scorecard reporting.^[1]

History

• 2000: nQuire formed: Larry Barbetta CEO
• 2001: nQuire courted by Siebel
• 2002: Siebel purchases nQuire
• 2005: Oracle purchases Siebel
• 2007: Hyperion Integration

References

1. ^ Переверзев, Николай (2003). "Управление предприятием с помощью системы Balanced Scorecard [Managing the enterprise with the help of the "Balanced Scorecard" system]" (in Russian). Финансовый Директор 3. http://www.cfin.ru/management/controlling/bsc/bsc_management.shtml. Retrieved 2011-03-31. "BSC можно реализовать как в специальных программных продуктах (например, Oros Scorecard, Hyperion Performance Scorecard, Oracle Scorecard и др.), так и в Excel.[One can implement BSC both in specialized software products (for example: Oros Scorecard, Hyperion Performance Scorecard, Oracle Scorecard, etc) as well as in Excel.]" 

• Cody, Edward (September 13, 2010). The Business Analyst's Guide to Oracle Hyperion Interactive Reporting 11 (1st ed.). Packt Publishing. ISBN 1849680361. https://www.packtpub.com/oracle-hyperion-interactive-reporting-11-1-business-analysts-guide/book. 

External links

• Oracle Business Intelligence Foundation
• OBIEE Documentation Library
• OBIEE Blogs
• "Siebel Acquires nQuire Software"
• Oracle Business Intelligence: tools overview and resources
• BI Tool Survey - Oracle OBIEE included
• OBIEE Resource: how to build report and dashboard