OBIEE Part I

Oracle Business Intelligence Enterprise Edition (OBIEE)

Oracle Business Intelligence Enterprise Edition (OBIEE) is a comprehensive suite of enterprise BI products that delivers a full range of analysis and reporting capabilities. Featuring a unified, highly scalable, modern architecture, OBIEE provides intelligence and analytics from data spanning enterprise sources and applications—empowering the largest communities with complete and relevant insight.
OBIEE consists of several interdependent components, with the Oracle BI Server at its core. For the purpose of this whitepaper, Oracle refers to these components as OBIEE:
Oracle BI Server — a highly scalable, highly efficient query and analysis server that integrates data via sophisticated query federation capabilities from multiple relational, unstructured, OLAP, and pre-packaged application sources, whether Oracle or non-Oracle. (Common enterprise business model and abstraction layer)

Oracle BI Answers — is 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 charts, pivot tables, reports, and dashboards. All of them are fully interactive. Analysis can be saved, shared, modified, formatted, or integrated in the user's personalized BI Dashboards.


Oracle BI Interactive Dashboard — are interactive Web architecture dashboards that display a required information to help users' decision making. Access to the information is interactive and based on the individual's role and identity. The end user works with live reports, charts, tables, prompts, pivot tables, and graphics and the user also has full capability for modifying and interacting with these results. Dashboard can aggregate content from other sources./e.g., the Internet, shared file servers, and document repositories/ The content of the Dashboard pages can be saved into Briefing Book.

Oracle BI Publisher — a highly scalable reporting engine capable of generating reports from multiple data sources in multiple formats via multiple delivery channels.

Oracle BI Briefing Books — reports that capture a series of snapshots of an Oracle BI Dashboard or report allowing the information to be viewed offline presentation style.

Oracle BI Disconnected Analytics — is a solution that offers BI Answers and Dashboards to mobile professionals on computers disconnected from the network. It provides the same intuitive interface for users whether they are working in a connected or disconnected mode.
.

Oracle BI Office Plug-In — automatically synchronizes information from Answers to Microsoft Word, Excel, and PowerPoint.

Oracle BI Delivers — is an alerting tool that provides monitoring and alerting of business activity. They are reached via multiple channels such as email, dashboards, and mobile devices. It includes Web-based self-service portal where users can create and subscript alerts. Dashboard can initiate and pass contextual information to other alerts to execute multistep, multiperson, and multiapplication analytical workflow. It can dynamically determine recipients and personalize content to reach right users at the right time and also with a right information.

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.


Oracle Business Intelligence Enterprise Edition: Overview
Oracle Business Intelligence Suite Enterprise Edition Plus (Oracle BI EE Plus) is a comprehensive suite of enterprise BI products that delivers a full range of analysis and reporting capabilities. Featuring a unified, highly scalable, modern architecture, Oracle BI EE Plus provides intelligence and analytics from data spanning enterprise sources and applications—empowering the largest communities with complete and relevant insight.
Business intelligence applications can be:
• Mission-critical and integral to an enterprise's operations or occasional to meet a special requirement
• Enterprise-wide or local to one division, department, or project
• Centrally initiated or driven by user demand

Adding filter prompts to requests :
A filter limits the results that appear when a request is run. Oracle BI Answers shows only those results that match the criteria.

To simplify filtering, Oracle BI Answers provides two types of prompts, dashboard prompts and criteria prompts:
 A dashboard prompt is a special kind of filter that filters requests embedded in a dashboard. A dashboard prompt filters embedded requests that contain the same columns as the filter. It can filter all embedded requests in a dashboard, or embedded requests on the same dashboard page.

Multiple columns in a dashboard prompt can be used to constrain users' choices for subsequent selections. For example, if one column filters on a region, and the next column filters on districts, the district column can be constrained to show only districts in the region the user selects. A dashboard prompt can also be populated dynamically so that it can be programmatically customized for each user.

A criteria prompt guides users in making selections for individual requests. There are two kinds of criteria prompts, column filter prompts and image prompts:

A column filter prompt provides general filtering of a column within a request. A column filter prompt can present all choices for a column, or, like a dashboard prompt, it can present constrained choices for a column. For example, if a request contains a Region=East filter, constraining choices for the City column restricts the selections to cities in the East region only. This eliminates the selection of a mutually exclusive filter that could result in no data.

An image prompt provides an image that users click to select criteria for a request. For example, in a sales organization, users can click their territories from an image of a map to see sales information, or click a product image to see sales information about that product. Users who know how to use the HTML