13 October, 2020
The intent of this OBIEE 11g tutorial is to provide an in-depth understanding of the OBIEE 11g product of Oracle. In these tutorials, we will go through the OBIEE Architecture and features of OBIEE 11g. We will also focus on creating and understanding of certain tasks such as Creating Repository, Measures, Joins, Physical and Business layers, and many more.
In addition to free tutorials, we will also look at common issues and interview questions of OBIEE 11g product.
Let's get started.
Oracle Business Intelligence Enterprise Edition 11g (OBIEE) is an unmatched and comprehensive business intelligence and analytics platform that delivers a full range of capabilities—including interactive dashboards, ad hoc queries, mobile analytics, notifications and alerts, enterprise and financial reporting, scorecard and strategy management, business process invocation, unstructured search and collaboration, integrated systems management and more. OBIEE 11g is built on a proven and modern technological foundation that supports the highest workloads and most complex deployments while providing timely insights to users across an enterprise at a low overall total cost of ownership.
There are three layers in OBIEE 11g Repository Physical Layer: This layer is used for
- Importing data
- Creating Aliases
- Building physical joins
- Setting up the connection pool and its properties
- Enabling/ Disabling cache for individual table
BMM(Business Model & Mapping) Layer: This layer is used for
- Writing the business logic
- Creating Logical columns and tables
- Creating hierarchy
- Creating LBM (level based measures)
- Creating shares
- Creating Time series functions
- Creating Fragmentation on tables
- Creating filters on repository
Presentation Layer: This layer is used for
- Arranging the data for users view (Folder Structure)
- Creating Presentation hierarchy
- Creating Implicit Fact column
- Implementing Column level security
The below diagram describes the standard logical architecture of Oracle business intelligence 11g system
The entire system architecture is called BI Domain, this BI Domain divided into Java components and non-Java components. Java components are WebLogic server Domain components and non-java components are Oracle BI system components.
This domain consists of a Managed server and Admin Server. These services comprise mainly with all the java modules to trigger the java services.
Admin Server: A JEE container that runs in a dedicated Java virtual machine that contains Java components for administering the system. It typically triggers the start, stops kind of admin activity for his peer Manager server processes.
Managed Server: A JEE container that runs in a dedicated Java virtual machine that provides the run-time environment for the Java-based services and applications within the system. The services comprise of BI plug-in, Security, publisher, SOA, BI Office services, etc
Node Manager: Node Manager is a separate java utility run to trigger the auto start, stop, restart activities and it provides process management services for the Admin Server and Managed Server.
Oracle Process Manager and Notification Server (OPMN): By using this OPMN services we can stop and start all system components of BI. It is monitored, managed, and controlled by Fusion Middleware Controller.
Oracle Weblogic Server (Console):
- Monitoring health and performance of JEE servers· Configuring WebLogic domains· Stopping and starting JEE servers· Viewing JEE server logsFusion Middleware Control:
Fusion Middleware Control is a browser-based tool and the recommended method for monitoring, managing, and configuring Oracle Business Intelligence components.
Starting, stopping, and restarting all system components (BI Server, BI Presentation Server) and Managed Servers
Deployed as one or more Java EE applications:
Administrative Components — Enterprise Management applications and JMX MBeans for managing all configuration and run-time settings for Oracle Business Intelligence.
Oracle BI Publisher — This component provides an enterprise reporting solution for authoring, managing, and delivering all types of highly formatted documents to employees, customers, and suppliers.
Oracle BI Office — This component provides the integration between Oracle Business Intelligence and Microsoft Office products.
Oracle BI Action Services — This component provides the dedicated Web services that are required by the Action Framework and that enables an administrator to manually configure which Web service directories can be browsed by users when they create actions.
Oracle Real-Time Decisions (Oracle RTD) — This component provides enterprise analytics software solutions that enable companies to make better decisions in real-time at key, high-value points in operational business processes.
Oracle BI Security Services — This component provides dedicated Web services that enable the integration of the Oracle BI Server with the Oracle Fusion Middleware security platform i.e JPS (Java Platform Security) , CSF (Credential Store Framework), and users and groups managed by BI LDAP security.
Oracle BI SOA Services — This component provides dedicated Web services for objects in the Oracle BI Presentation Catalog, to invoke analyses, agents, and conditions. They make it easy to invoke Oracle Business Intelligence functionality from the Business Process Execution Language (BPEL) processes.
Oracle BI Plug-in — A JEE application that routes HTTP and SOAP requests to Oracle BI Presentation Services.
Deployed as non-JEE components, such as processes and services written in C++ and J2SE:
Oracle BI Server — This component provides the query and data access capabilities at the heart of Oracle Business Intelligence and provides services for accessing and managing the enterprise semantic model (stored in a file with a .RPD extension).
Oracle BI Presentation Services — This component provides the framework and interfaces for the presentation of business intelligence data to Web clients. It maintains an Oracle BI Presentation Catalog service on the file system for the customization of this presentation framework.
Oracle BI Scheduler — This component provides extensible scheduling for analyses to be delivered to users at specified times. (Oracle BI Publisher has its own scheduler)
Oracle BI JavaHost — This component provides component services that enable Oracle BI Presentation Services to support various components such as Java tasks for Oracle BI Scheduler, Oracle BI Publisher, and graph generation.
Oracle BI Cluster Controller — This component distributes requests to the BI Server, ensuring requests are evenly load-balanced across all BI Server process instances in the BI domain.
Oracle Business Intelligence on multiple hosts
Oracle Business Intelligence can be installed and configured on multiple hosts.
OBIEE components are mainly divided into two types of components −
Server components are responsible to run the OBIEE system and client components interact with users to create reports and dashboards.
Following are the server components − Oracle BI Server
This component is the heart of the OBIEE system and is responsible to communicate with other components. It generates queries for report requests and they are sent to the 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 the OBIEE server.
OBIEE Application Server
OBIEE Application Server helps to work on client components and Oracle provides Oracle10g Application server with the OBIEE suite.
It is responsible to schedule jobs in the OBIEE repository. When you create a repository, OBIEE also creates 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.
OBIEE has two types of client components
Browser (Web )based client
The following are some client components −
The following tools are provided in OBIEE web-based client −
Interactive Dashboards: Dashboard is a logical container of components developed by OBIEE like answers, other web pages, other dashboards. This provides additional features like prompts, guided navigation, etc.
Answers: Oracle BI Answers also called reports provide highly Interactive user interfaces to generate reports/analytics with complex calculations and multiple views and filters etc.
Oracle Delivers: Create proactive alerts with the help of an engine called iBots. It also helps to deliver the contents in various formats to different. Destinations.
Disconnected Analytics: Simulated online working environment even though not connected to data warehousing.
MS_Office Plugin: Integrates the OBIEE generated data with all MS_Office products which can further be analyzed on local desktop Office products.
BI presentation Service Administration: The client component helps to admin the activities which are being in progress within presentation services.
BI Publisher: OBI publisher which was known as XML publisher allows us to create reports based on the layouts created in MS Word or Excel. The report output can be published/burst to various media and various people.
In Non-Web based client, the 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 the database and execute SQL commands.
Our course design of tutorials is practical and informative. At TekSlate, we offer resources to help you learn various IT courses. We avail of both written material and demo video tutorials. For in-depth knowledge and practical experience explore Online OBIEE Training.