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 E XTRACTION M A T I O N T R A N S F O R L OAD ODS STAGING LOAD DATA MART 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