OBIEE stands for Oracle Business Intelligence Enterprise Edition, a set of Business Intelligence tools and is provided by Oracle Corporation. It enables the user to deliver robust set of reporting, ad-hoc query and analysis, OLAP, dashboard, and scorecard functionality with a rich end-user experience that includes visualization, collaboration, alerts and many more options.

Key Points

OBIEE provides robust reporting which makes data easier for business users to access.
OBIEE provides a common infrastructure for producing and delivering enterprise reports, scorecards, dashboards, ad-hoc analysis, and OLAP analysis.
OBIEE reduces cost with a proven web-based service-oriented architecture that integrates with existing IT infrastructure.
OBIEE enables the user to include rich visualization, interactive dashboards, a vast range of animated charting options, OLAP-style interactions, innovative search, and actionable collaboration capabilities to increase the user adoption. These capabilities enable your organization to make better decisions, take informed actions, and implement more-efficient business processes.

Competitors in the Market

The main competitors of OBIEE are Microsoft BI tools, SAP AG Business Objects, IBM Cognos and SAS Institute Inc.

As OBIEE enables the user to create interactive dashboards, robust reports, animated charts and also because of its cost-effectiveness, it is widely used by many companies as one of main tool for Business Intelligence solution.

Advantages of OBIEE

OBIEE provides various types of visualizations to insert in dashboards to make it more interactive. It allows you to create flash reports, report templates, and ad-hoc reporting for end users. It provides close integration with major data sources and can also be integrated with third party vendors like Microsoft to embed data in PowerPoint presentations and word documents.

Following are the key features and benefits of OBIEE tool −

Features	Key Benefits of OBIEE
Interactive Dashboards	Provides fully interactive dashboards and reports with a rich variety of visualizations
Self-serve Interactive Reporting	Enable business users to create new analyses from scratch or modify existing analyses without any help from IT
Enterprise Reporting	Allows the creation of highly formatted templates, reports, and documents such as flash reports, checks, and more
Proactive Detection and Alerts	provides a powerful, near-real-time, multi-step alert engine that can trigger workflows based on business events and notify stakeholders via their preffered medium and channel
Actionable Intelligence	Turns insights into actions by providing the ability to invoke business processes from within the business intelligence dashboards and reports
Microsoft Office Integration	Enables users to embed up-to-the-minute corporate data in Microsoft PowerPoint, word, and Excel documents
Spatial Intelligence via Map-based Visualizations	Allows users to visualize their analytics data using maps, bringing the intuitiveness of spatial visualization to the world of business intelligence

How to Sign in to OBIEE?

To sign into OBIEE, you can use web URL, user name and password.

To sign into Oracle BI Enterprise Edition −

Step 1 − In the Web browser address bar, enter URL to access OBIEE.

The “Sign In page” is displayed.

Step 2 − Enter your user name and password → Select the language (You can change the language by selecting another language in the User Interface Language field in the My Account dialog Preferences tab”) → Click on Sign In tab.

It will take you to the next page as per configuration: OBIEE homepage as shown in the following image or to My Dashboard page/Personal Dashboard or a Dashboard specific to your job role.

OBIEE – ComponentsOBIEE components are mainly divided into two types of components −

Server Components
Client Components

Server components are responsible to run OBIEE system and client components interact with user to create reports and dashboards.

Server Components

Following are the server components −

Oracle BI (OBIEE) Server
Oracle Presentation Server
Application Server
Scheduler
Cluster Controller

Oracle BI Server

This component is the heart of OBIEE system and is responsible to communicate with other components. It generates queries for report request and they are sent to database for execution.

It is also responsible for managing repository components which are presented to the user for report generation, handles security mechanism, multi user environment, etc.

OBIEE Presentation Server

It takes the request from users via browser and passes all requests to OBIEE server.

OBIEE Application Server

OBIEE Application Server helps to work on client components and Oracle provides Oracle10g Application server with OBIEE suite.

OBIEE Scheduler

It is responsible to schedule jobs in OBIEE repository. When you create a repository, OBIEE also create a table inside the repository which saves all schedule-related information. This component is also mandatory to run agents in 11g.

All jobs which are scheduled by the Scheduler can be monitored by the job manager.

Client Components

Following are some client components −

Web-based OBIEE Client

Following tools are provided in OBIEE web-based client −

Interactive Dashboards
Oracle Delivers
BI Publisher
BI Presentation Service Administrator
Answers
Disconnected Analytics
MS Office Plugin

Non-Web based Client

In Non-Web based client, following are the key components −

OBIEE Administration − It is used to build repositories and has three layers − Physical, Business, and Presentation.
ODBC Client − It is used to connect to database and execute SQL commands.

OBIEE – Architecture

OBIEE Architecture involves various BI system components which are required to process the end user’s request.

How OBIEE System Actually Works?

The initial request from the end user is sent to the Presentation server. The Presentation server converts this request in logical SQL and forwards it to BI server component. BI server converts this into physical SQL and sends it to database to get the required result. This result is presented to the end user through the same way.

The following diagram shows detailed OBIEE Architecture −

OBIEE Architecture contains Java and non-Java components. Java components are Web Logic Server components and non-Java components are called Oracle BI system component.

Web Logic Server

This part of OBIEE system contains Admin Server and Managed Server. Admin server is responsible for managing the start and stop processes for Managed server. Managed Server comprises of BI Plugin, Security, Publisher, SOA, BI Office, etc.

Node Manager

Node Manager triggers the auto start, stop, restart activities and provides process management activities for Admin and Managed server.

Oracle Process Manager and Notification Server (OPMN)

OPMN is used to start and stop all components of BI system. It is managed and controlled by Fusion Middleware Controller.

Oracle BI System Components

These are non-Java components in an OBIEE system.

Oracle BI Server

This is the heart of Oracle BI system and is responsible for providing data and query access capabilities.

BI Presentation Server

It is responsible to present data from BI server to web clients which is requested by the end users.

Scheduler

This component provides scheduling capability in BI system and it has its own scheduler to schedule jobs in OBIEE system.

Oracle BI Java Host

This is responsible for enabling BI Presentation server to support various Java tasks for BI Scheduler, Publisher and graphs.

BI Cluster Controller

This is used for load balancing purposes to ensure that the load is evenly assigned to all BI server processes.

So, this brings us to the end of blog. This Tecklearn ‘Overview of Oracle Business Intelligence Edition’ blog helps you with commonly asked questions if you are looking out for a job in Oracle BI. If you wish to learn OBIEE and build a career in Business Intelligence domain, then check out our interactive, Oracle Business Intelligence Enterprise Edition (OBIEE) Training, that comes with 24*7 support to guide you throughout your learning period. Please find the link for course details:https://www.tecklearn.com/course/oracle-business-intelligence-enterprise-edition-training-and-certification/

Oracle Business Intelligence Enterprise Edition (OBIEE) Training

About the Course

Oracle Business Intelligence Enterprise Edition (OBIEE) Training and Certification training course lets you master the Oracle Business Intelligence and Analytics platform. You will gain in-depth knowledge on OBIEE advanced features, BI dashboards, reports, etc., through hands-on training sessions. This course is meant to provide detailed knowledge of the OBIEE 12c. You will be trained in various Business Intelligence scenarios, BI life cycle, concepts of OLAP and working with charts and graphs.

Why Should you take OBIEE Training?

The average salary for “oracle business intelligence consultant” ranges from approximately $76,703 per year for Business Consultant to $113,285 per year for Full Stack Developer. -Indeed.com.
Oracle Business Intelligence has a market share of around 8% globally.
OBIEE gives you experience with next-generation solutions that can help strategize, plan and optimize business operations. Allow you to become an Oracle Certified Expert or Oracle Implementation Specialist of an in-demand solution.

What you will Learn in this Course?

Data Modelling and Data Warehousing Concepts

Introduction to Oracle Business Intelligence Enterprise Edition (OBIEE)
Data models
Data warehousing
Data modelling implications and the impact of Data modelling on business intelligence

Business Intelligence Concepts

Overview of Business Intelligence
Description of BI Stack: BI technology, BI Server and BI Scheduler
Need for reporting in business
Difference between OLTP and OLAP
Multidimensional and relational analytical processing

OBIEE Installation

OBIEE Installation (12c)
Oracle Business Intelligence Suite
Architecture of OBIEE
Key features and components

Online Analytical Processing (OLAP)

Concept of Online Analytical Processing
Significance of OLAP in business intelligence life cycle
Star Schema and Designing with Star Schema
Enterprise information model
Snow flake and constellation

Oracle BI Repository

What is Oracle Business Intelligence Repository?
Directory structure installation, services,
Analytics and interactive reporting,
Dashboard creation and multiple report creation

Business Intelligence Repository Business Model

How to build a Business Model and Mapping Layer in BI Repository
Data format, Conditional format, Removing filters,
Report Saving
Creation of new folder
Working with the Enterprise Manager
Testing and validation of the Repository
Understanding the process of Cache disabling
Dashboard prompt and filtering

Dashboard Creation

Creation and Setup of OBIEE Dashboard
Basics of OBIEEE dashboard
Deploying Dashboard Builder for building Dashboards
Edit, Share and Save options in Dashboard analysis
Process of Cache creation and clearing
ODBC functions
Logical Table Source, Summary and Detail Report

OBIEE Repository

OBIEE Repository
Creation of Test Report and adding calculations
Deployment of OBIEE analysis
Repository variables, session and presentation variables

OBIEE Security & Management

Securing the Oracle Business Intelligence Suite with Enterprise Manager
Creation of alerts and notifications
Administration, Maintenance and Grouping
Types of security in OBIEE
Task and folder level security

Differences between OBIEE 11g and 12c

Hands on Variables

New Features of OBIEE 12c

Repository Development
Catalog Development
Deployment-Online
RPD Deployment

482