OBIEE 11g Tutorials
OBIEE 11g Tutorials Overview
The intent of this OBIEE 11g tutorial is to provide in-depth understanding of 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.
Lets get started.
- Loading the Repository in OBIEE
- OBIEE Interview Questions & Answers
- Checking In and Publishing a MUDE Project in OBIEE 11g
- Reviewing Multiuser Options During Development in OBIEE 11g
- Making Changes to the Repository in OBIEE
- Checking Out a Project in OBIEE 11g
- Setting Up Users and Pointing to the Multiuser Directory
- Setting Up the MUDE Directory in OBIEE
- Creating a Project in OBIEE 11g
- Setting Up a Multiuser Development Environment in OBIEE
- Create a Measure Using the PERIODROLLING Function in OBIEE
- Create a Measure Using the TODATE Function in OBIEE
- Create Presentation Layer Objects in OBIEE
- Create Presentation Layer Objects – Part II in OBIEE
- Create Logical Table and Logical Columns & Logical Join in
- Creating Logical Dimensions with Parent-Child Hierarchies in OBIEE
- Create a Share Measure in OBIEE
- Creating Level-Based Measures in OBIEE
- Set Aggregation Content for Logical Table Sources in OBIEE
- Associate Time Logical Columns with Logical Levels in OBIEE
- Create a Logical Dimension for Time in OBIEE
What is OBIEE?
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.
What are the different layers of OBIEE 11g Repository?
There are three layers in OBIEE 11g Repository
Physical Layer: This layer is used for
- Importing data
- Creating Aliases
- Building physical joins
- Setting up 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
Oracle Business Intelligence System Logical Architecture
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.
Weblogic Server Domain
This domain consists of Managed server and Admin Server. These services comprises 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 trigger the start, stop 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 comprises of BI plug-in, Security, publisher, SOA, BI Office services etc
Node Manager: Node Manager is a separate java utility runs 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 logs
Fusion 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
- Starting, stopping, and restarting all system components (BI Server,BI Presentation Server) and Managed Servers
- Managing performance and monitoring system metrics(DMS-Dynamic Monitoring System)
- Performing diagnostics and logging (ODL-Oracle Diagnostic Logging)Fusion Middleware Control also provides access to Oracle WebLogic Server Administration Console, where you monitor and manage Oracle Business Intelligence Java components.
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 enable 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 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 interface 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 components 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 11g Components
OBIEE components are mainly divided into two types of components −
Server components are responsible to run OBIEE system and client components interact with user to create reports and dashboards.
Following are the server components −
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.
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.
OBIEE has two types of client components
Browser (Web )based client
Non web based client
Following are some client components −
Web-based OBIEE Client
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 as reports provides a 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 a 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 ware housing.
MS_Office Plugin : Integrates the OBIEE generated data with all MS_Office product which can further analyzed on local desktop Office products.
BI presentation Service Administration : Client component helps to admin the activities which are being in progress within presentation services.
BI Publisher : OBI publisher which was knows as XML publisher allows to create reports based on the layouts created in MS word or Excel. The report output can be published/bursted to various media and various people.
Non Web based OBIEE 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.
Our course design of tutorials is practical and informative. At TekSlate, we offer resources to help you learn various IT courses. We avail both written material and demo video tutorials. For in-depth knowledge and practical experience explore Online OBIEE Training.