Slide 1

Report
OBIEE Implementation
An Overview
Presented by:
James VanAuken
1
Remember a long time ago?
Fat client
DATABASE
Reporting Tool Client
25 MB average on desktop
• New BI systems
– One vendor
– Complete functional package with all featurs
2
Complete enterprise BI solution
2 parts
3
Oracle BI Foundation
4
Oracle BI solution is complete
5
Oracle Business Intelligence Enterprise Edition Plus
Definition with simplistic diagram
Oracle’s flagship platform for delivering reports, dashboards and analytics
across multiple data sources. Powered by the Oracle BI Server and with
connectivity to most databases, OLAP servers and ERP applications, Oracle BI
Enterprise Edition Plus is a best-of-breed solution that provides reporting and
analytic capabilities.
6
OBIEE BI Publisher
Planning to implement – sample below
7
OBIEE EE PLUS
8
Oracle Delivers Server
9
Oracle BI Publisher
10
Oracle Presentation Server
11
OBIEE Solution - consistent data, security, flexible
12
OBIEE – Answers – Presentation Layer
Personnel Information Systems Directorate
13
OBIEE - AW2 – Logical Layer
The heart of BI reporting
14
From OLTP to the Data Warehouse
OLTP
SYSTEM(S)
THIRD
PARTY
OTHER
SOURCES
EXTRACTION
T
R
A
N
S
F
O
R
M
A
T
I
O
N
ODS
DATA MART
LOAD
STAGING
LOAD
DATA MART
DATA MART
DATA MART
15
Screen Shot – ETL Application
Oracle Warehouse Builder (OWB)
16
Screen Shot – EL-T Application
Oracle Data Integrator (ODI)
17
Future?
Oracle Master Data Management
18
Future?
Enhanced Data Warehouse
19

similar documents