What I have learn about OBIEE training

We studies this topic around 5 days by our VTC trainer named Ms Sin Hui.

Outline:

Introduction to Business Intelligence 
Introduction to Oracle BI EE 
OBIEE Architecture Component Overview
OBIEE Installation 
Start Stop Server 
Configuration and Log File

Introduction to Business Intelligence 

- What is Business Intelligence? 

Business Intelligence (BI) is: “The processes, technologies and tools needed to turn data into information and information into knowledge and knowledge into plans that drive profitable business action. BI encompasses data warehousing, business analytics and knowledge management.”
The Data Warehouse Institute, Q4/2002

Business Intelligence is defined as "knowledge gained about a business through the use of various hardware/software technologies which enable organizations to turn data into information”.
Data Management Review

- What is Oracle Business Intelligence?

• Portfolio of technology and applications that provides the industry's first integrated, end-to-end Enterprise Performance Management System, including BI foundation and tools

• Provides user the data and tools to answer questions that are important to running the part of the business for which they are responsible: – Determine whether the business is on track – Identify where things are going wrong – Take and monitor corrective actions – Sport trends

- Oracle Business Intelligence Enterprise Edition 11g (OBIEE) 

• Oracle BI Enterprise Edition 11g is a comprehensive business intelligence platform that delivers a full range of analytic and reporting capabilities.

• Facilitates data analysis, mining and publishing capabilities on top of physical data warehouse.

There are number of capabilities within the suit.
•Role-based dashboards
•Proactive alerts -> ability to send proactive alerts using delivers application
•Mobile access
•MS Office integration
•Logical view of data
•Query processing and modeling
•Planning and what-if analysis
•Multiple data sources

Introduction to Oracle BI EE 

• Oracle Business Intelligence (OBIEE) is a reporting tool used to develop and access the reports.

• OBIEE is a robust report development and delivery tool that contains a range of reporting features. Its reporting contents delivered through dashboards.

OBIEE Architecture Component Overview

Figure 1 : Oracle BI Architecture Components

Presentation Services 

Presentation Services includes end-user tools that provide access to business intelligence information.

• Oracle BI Analysis Editor
 – Set of graphical tools used to build, view, and modify Oracle BI analyses
• Oracle BI Dashboard
 – Display the results of analyses and other items

Oracle BI Presentation Server and Catalog 

Presentation Server provides processing to visualize information for end-user consumption.
• Uses the Presentation Catalog to store saved content
• Receives data from Oracle BI Server and provides it to the enduser tool that requested it

Oracle BI Server 

Oracle BI Server is the core server behind Oracle Business Intelligence.
• Provides efficient processing to access physical data sources and structure information
– Uses metadata to direct processing
– Generates dynamic SQL to query data in the physical data sources
– Structures results to satisfy requests
– Provides BI data to Oracle BI Presentation Services

Oracle BI Repository 

The BI repository stores the metadata used by Oracle BI Server. • Accessed and configured using the Oracle BI Administration Tool, which is used by administrator to:
– Import metadata from databases and other data sources
– Simplify and reorganize the metadata into business models
– Structure the business model for presentation to analysis and dashboard users

Data Sources 

Data sources contain the business data that users want to analyze
• Accessed by Oracle BI Server
• Can be in any format, such as:
– Relational databases
– Online analytical processing (OLAP) databases flat files
– XML for Analysis (XMLA)

OBIEE Installation 

The Oracle Business Intelligence installation package includes the following products, with all the technology required to install, configure, and run them:
• Oracle BI EE
• Oracle BI Publisher
• Oracle BI Add-in for Microsoft Office
• Oracle BI Administration Tool

Tasks in the Oracle BI Installation Procedure 

Task 1: 
• Obtain the Oracle Business Intelligence installation media through one of the following methods:
– Oracle Business Intelligence installation DVD
– Oracle Technology Network (OTN)
– Oracle Software Delivery Cloud

Task 2: 
• Complete the installation planning requirements.
• Ensure that your system environment meets the installation requirements for Oracle Fusion Middleware, Oracle Business Intelligence, and the Repository Creation Utility (RCU).

Task 3: 
• Have a database installed and have the required database schemas loaded.
• Oracle Business Intelligence requires certain schemas to be installed in a supported database. You do this by running RCU on a pre-existing database.
• Ensure that a supported database is running, and then run RCU to create the necessary schemas.

Task 4:
 • Install Oracle Business Intelligence.

Task 5:
 • Configure Oracle Business Intelligence.

Start Stop Server 

Starting & Stopping Oracle BI 

• Oracle Business Intelligence runs within Oracle WebLogic Server, and therefore Oracle WebLogic Server must be started before Oracle Business Intelligence components can be started and maintained.

• To make changes to server configuration settings, the Oracle BI Presentation Catalog, the repository (.rpd file offline), and other settings, you must restart the appropriate Oracle Business Intelligence components before those changes can take effect.

Start oracle database 

• Open command prompt
• Key in command : . oraenv
• orcl
• sqlplus / as sysdba
• startup
• exit
• lsnrctl start

Start OBIEE 

1.Weblogic 
• cd /home/oracle/bi11g/user_projects/domains/bifoundation _domain/bin • ./startWebLogic.sh

2.Node Manager 
• cd /home/oracle/bi11g/wlserver_10.3/server/bin
• ./startNodeManager.sh

3.Managed Server 
• cd /home/oracle/bi11g/user_projects/domains/bifoundation _domain/bin • ./startManagedWebLogic.sh bi_server1 t3://vtchost:7001

4.Oracle Process Manager and Notification server (OPMN) 
• cd bi11g/instances/instance1/bin
• ./opmnctl startall
• ./opmnctl status

Stop OBIEE 
1.Oracle Process Manager and Notification server (OPMN)  
• cd bi11g/instances/instance1/bin
• ./opmnctl stopall

2.Managed Server 
• cd /home/oracle/bi11g/user_projects/domains/bifoundation _domain/bin • ./stopManagedWebLogic.sh bi_server1 t3://vtchost:7001

3.Node Manager 
• pkill -TERM -u oracle -f "./startNodeManager.sh"
• pkill -TERM -u oracle -f "/java"

4.weblogic
• cd /home/oracle/bi11g/user_projects/domains/bifoundation _domain/bin • ./stopWebLogic.sh

Configuration and Log File

Figure 2

Figure 3

For any inqueries please visit

www.vtcholding.com

Vision Technology Consulting Sdn Bhd
(Malaysia - Klang Valley)
Suite 3-1, 3rd Floor,
Block 4800, CBD Perdana,
Off Persiaran Multimedia,
63000 Cyberjaya,
Selangor, Malaysia

Office: +603 8322 0127 Fax:+603 8319 4510