Leveraging Oracle Business Intelligence Tools with the Oracle OLAP option

1
(No Transcript)
2

• Leveraging Oracle Business Intelligence Tools
  with the Oracle OLAP option
• Bud Endress
• Director, Product Management, OLAP option
• Oracle Corporation
• Hemant Verma
• Sr. Product Manager, OLAP option
• Oracle Corporation

3
Agenda

• Problem statement
• Review of the OLAP option to the Oracle10g
  Database
• Demonstration

4
Problem Statement

• The typical data warehouse infrastructure
  fragments data and business rules
• Increased costs
• Inconsistent analysis

5
Fragmentation

• Types of fragmentation
• Subject specific data marts
• Sales, finance, human resources, etc.
• Geographically fragmented data
• Americas, Europe, Asia Pacific, etc.
• Database technology fragmentation
• Relational and multidimensional
• Tools induced fragmentation
• Separate tools for relational and
  multidimensional databases

6
Fragmentation

• What if you had
• Five subject areas
• Five geographic regions
• Relational and multidimensional analysis of each
• Separate tools for both relational and
  multidimensional databases

7
Fragmentation

• You would have
• 50 separate databases to manage
• Latency and synchronization problems
• Business rules in each database and in each tool
• You would not have a single, unified view of the
  enterprise with
• A single version of the data
• Consistency of business rules

8
Geographic Fragmentation
9
Technology Fragmentation
10
Tools Fragmentation
Profit AB-C
Profit BCD
Profit ACD
Profit ACD-E
Replication data to Multidimensional database
Warehouse ETL Process
Relational Data Warehouse
Multidimensional Database
Sources
11
Fragmentation
SQL
Relational Tools
Data Replication Process
Multidimensional Tools
OLAP APIs
Multidimensional Databases
Tools
Data Warehouse
12
Fragmentation
Profit ACD-E
SPREADSHEET
13
OLAP Option to the Oracle Database
SQL
Relational Data Types
OLAP API
Multidimensional Data Types
Data Warehouse
14
OLAP Option to the Oracle Database
Profit ACD-E
15
Demonstrations
16
Oracle HTML DB
17
Oracle HTML Database
HTML Database
Denormalized Fact View
OLAP_TABLE
Relational
Multidimensional
18
Oracle Discoverer
19
Oracle Discoverer Relational Context
Discoverer (dimensional context)
Dimension views and base level fact views over
analytic workspace
Summary views over analytic workspace
query rewrite
OLAP_TABLE
Analytic Workspace
20
Oracle Discoverer Dimensional Context
Discoverer (dimensional context)
OLAP API
RDBMS Views
OLAP_TABLE
Relational
Multidimensional
21
Oracle Reports
22
Oracle Reports Relational Context
Reports
Denormalized Fact View
OLAP_TABLE
Relational
Multidimensional
23
Oracle Reports Dimensional Context
Reports
OLAP Pluggable Data Source
OLAP API
RDBMS Views for OLAP API
OLAP_TABLE
Relational
Multidimensional
24
Forecasting Application
25
The front end application Written in Java
using Oracle Business Intelligence Beans
OLAP API
RDBMS Views for OLAP API
PL/SQL
OLAP_TABLE
Oracle10g Database the applications OLAP DML
program
FORECAST_UNITS program
Analytic Workspace
26
OLAP Add-in for Excel
27
OLAP Add-in for Excel
Excel
OLAP Spreadsheet Add-in
Query Builder Bean
Calculation Builder Bean
Data Beans
RDBMS Views for OLAP API
OLAP_TABLE
Relational
Multidimensional
28
(No Transcript)