Business Objects and Oracle9i OLAP Jason Kuo OracleWorld

Business Objects and
Oracle9i OLAP
Jason Kuo
OracleWorld
Topics
• Introducing Business Objects and Enterprise 6
• Oracle and Business Objects product integration
• Business Objects and Oracle9i OLAP
Slide 2 - - Copyright © 2003 Business Objects SA - All Rights Reserved
Technology Leader
Over a decade of constant innovation
•
Founded in 1990
•
Worldwide presence:
80 countries
•
Enterprise
Analytic
Applications
Set-Based
Analysis
Dual HQ: San Jose, CA / Paris,
France
BI
Repository
Semantic
Layer
Integrated
Pivot
Metadata
Bridging
Enterprise
6
Integrated
Web BI
Query From
Excel
Data
Integration
Integrated
Mobile BI
BI
Extranets
Integrated
OLAP
Application
Templates
1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003
Slide 3 - - Copyright © 2003 Business Objects SA - All Rights Reserved
Blue Chip Customers Across All Industries
More than 18,000 customers
bank
Slide 4 - - Copyright © 2003 Business Objects SA - All Rights Reserved
BusinessObjects Enterprise 6
Enterprise
Analytic
Applications
Business
Intelligence
Platform
Data
Integration
Products
Slide 5 - - Copyright © 2003 Business Objects SA - All Rights Reserved
Data Integration
The most productive DI platform on the market today
• Parallel performance
architecture for industrialstrength ETL
Q, R, A Tools
Management
Dashboards
Analytic
Applications
• A complete redesign of the
user interface
• Data preview and profiling
within design environment
• Impact analysis from sources
to end user reports
Custom
Applications
Web Data
Slide 6 - - Copyright © 2003 Business Objects SA - All Rights Reserved
RDBMS
Data
ERP Data
Customer
Data
Legacy
Data
Supplier Data
Data Integration with Oracle Applications
• Metadata browsing and import
• Browse through the Oracle Apps
organization of tables
• Show table descriptions and business
names
• Import Oracle Apps tables by name
• Types of objects supported
• PK/FK relationship information
• Descriptive flexfields
• Key flexfields
• Two-way real-time interface
• Initiate an insert/update/delete
request; subscribe to events
Slide 7 - - Copyright © 2003 Business Objects SA - All Rights Reserved
Query, Reporting, and Analysis
• BusinessObjects
• Integrated query, reporting,
and analysis
• A web-enabled full-client tool
• WebIntelligence
• All the power of Windows available
for the web
• True thin client for extranet users
• BusinessQuery for Excel
• The power and ease of use of
BusinessObjects data access
for Microsoft Excel users
Slide 8 - - Copyright © 2003 Business Objects SA - All Rights Reserved
Information Delivery
• InfoView
• A business intelligence portal
• Presents a secure, focused,
and personalized view
• Broadcast Agent
• Delivery of timely and personalized
information, and of business
driven alerts
• Schedule then publish, burst, email
• Dashboards and Scorecards
• Total flexibility to create dashboards
that match your business needs
• Provide a fast and effective way
of monitoring key measures
Slide 9 - - Copyright © 2003 Business Objects SA - All Rights Reserved
BI Deployment Infrastructure
• Designer
• Design tool to create the “semantic
layer” (metadata)
• Supervisor
• Security and user management
• Auditor
• Monitor, analyze, and optimize the BI
deployment.
• Developer Suite
• Development toolkit to customize,
integrate, and extend
BusinessObjects Enterprise 6
Slide 10 - - Copyright © 2003 Business Objects SA - All Rights Reserved
Dashboards
• Can be personalized and customized
• Unlimited analytics, gauges,
• Thumbnails on any page
• Combine analytics from multiple
applications in a single view
• Easy access to key performance
indicators (KPIs)
• Consolidated view
of the business
• Receive actionable alerts
Slide 11 - - Copyright © 2003 Business Objects SA - All Rights Reserved
Enterprise Analytic Applications
• Packaged analytic applications that span the
enterprise
• An integrated suite built on
the Business Objects
Warehouse
• Accelerates implementation
time
• Delivers packaged bestpractice analysis
Slide 12 - - Copyright © 2003 Business Objects SA - All Rights Reserved
Topics
• Introducing Business Objects and Enterprise 6
• Oracle and Business Objects product integration
• Business Objects and Oracle9i OLAP
Slide 13 - - Copyright © 2003 Business Objects SA - All Rights Reserved
Oracle and Business Objects Synergies
• Oracle DB
•
•
•
•
•
•
•
•
RDBMS
9i OLAP
10G Beta
Express
Oracle Applications
Oracle Portal
Oracle9iAS
Oracle Designer
Slide 14 - - Copyright © 2003 Business Objects SA - All Rights Reserved
Oracle and Business Objects Synergies
• Oracle DB
• Advanced SQL functions
-
Ranking
Cumulative Aggregate
Ratio to Report
Linear Regression
• 10G Beta program
-
Improved clustering
Higher availability
Enhanced business intelligence
Automated systems management
• Express
-
Ad-hoc querying and enterprise reporting on Express
Multi-source data integration within one report
Mobile computing—analyze data while offline
Rporting, scheduling, distribution, and web publishing for Express
data
Slide 15 - - Copyright © 2003 Business Objects SA - All Rights Reserved
Oracle and Business Objects Synergies
• Oracle Applications
• 10.x
-
Application Object Library (AOL)
Accounts Payable (AP)
Accounts Receivable(AR)
Bill Of Materials (BOM)
Engineering (ENG)
Fixed Assets (FA)
General Ledger (GL)
Human Resources (HR)
Inventory (INV)
Master Scheduling/MRP (MS/MRP)
Order Entry (OE)
Payroll (PAY)
Project Accounting (PA)
Purchasing (PO)
Work In Process (WIP)
Slide 16 - - Copyright © 2003 Business Objects SA - All Rights Reserved
• 11.x
-
Payroll
Projects
Purchasing
Work in Process
Cash Management
Capacity
Engineering
Sales and Marketing
Service
Order Management
Shipping module
Data Integration with Oracle Applications
• Metadata browsing and import
• Browse through the Oracle Apps
organization of tables
• Show table descriptions and business
names
• Import Oracle Apps tables by name
• Types of objects supported
• PK/FK relationship information
• Descriptive flexfields
• Key flexfields
• Two-way real-time interface
• Initiate an insert/update/delete
request; subscribe to events
Slide 17 - - Copyright © 2003 Business Objects SA - All Rights Reserved
Oracle and Business Objects Synergies
• Oracle Portal
• Embed Enterprise 6
• Oracle9iAS
• Fully supported
• Oracle Designer
• Share CWM models
Slide 18 - - Copyright © 2003 Business Objects SA - All Rights Reserved
Topics
• Introducing Business Objects and Enterprise 6
• Oracle and Business Objects product integration
• Business Objects and Oracle9i OLAP
Slide 19 - - Copyright © 2003 Business Objects SA - All Rights Reserved
Architecture
• Build from AW, OLAP engine, Relational View, flat table
Slide 20 - - Copyright © 2003 Business Objects SA - All Rights Reserved
Business Objects 9i OLAP Access
APPLICATION
• Innovative way of SQL
access to 9i OLAP
Analytic Workspaces
Returns data through
OCI or JDBC
SELECT Statement
RELATIONAL ENGINE
Select list and WHERE
clause predicates
Returns data in
Row format
OLAP_TABLE
OLAP DML commands
Aggregation and
calculation
Slide 21 - - Copyright © 2003 Business Objects SA - All Rights Reserved
Returns data in
multidimensional
format
MULTIDIMENSIONAL ENGINE
Business Objects 9i OLAP Access
• Business Objects 9i OLAP
access advantages
• Resolve relational view
challenges
• Fully leverage 9i OLAP
server side calculations
and create custom local
calculation
• Integrate both 9i OLAP
and 9i relational data
Slide 22 - - Copyright © 2003 Business Objects SA - All Rights Reserved
Access Any Data Source
Databases
Oracle
IBM
SQL Server
Teradata
Red Brick
ODBC…
Data Marts
Warehouses
Normalized
ODS
Star
Snowflake…
ERP,
CRM
SAP
PeopleSoft
Baan
Oracle Financials
Siebel…
OLAP
Servers
Local
Data
Hyperion Essbase Text
SAP BW
Excel…
SQL Server
Analysis Services…
Slide 23 - - Copyright © 2003 Business Objects SA - All Rights Reserved
Internet
HTML
XML…
The Semantic Layer
• The semantic layer may consist of one or more universes
• Each universe is a partial representation of a database, in the form of
business vocabulary
Sales/Marketing
Human
Resources
Employee
Salary
Benefits...
Slide 24 - - Copyright © 2003 Business Objects SA - All Rights Reserved
Sales Revenue
Sales Executive
Customer
Product
Price
Order Date ...
Business Objects Universe
Graphical, easy creation of the semantic layer
• Fast universe creation
• In a few mouse clicks
• Leverage existing
metadata
• Resolve data schema
difficulties
• Exploit DW power
• Aggregate awareness
Slide 25 - - Copyright © 2003 Business Objects SA - All Rights Reserved
Slide 26 - - Copyright © 2003 Business Objects SA - All Rights Reserved
Business Objects 9i OLAP Access
• Business Objects 9i OLAP
access advantages
• Resolve relational view
challenges
• Fully leverage 9i OLAP
server side calculations
and create custom local
calculation
• Integrate both 9i OLAP
and 9i relational data
Slide 27 - - Copyright © 2003 Business Objects SA - All Rights Reserved
Slide 28 - - Copyright © 2003 Business Objects SA - All Rights Reserved
Slide 29 - - Copyright © 2003 Business Objects SA - All Rights Reserved
Business Objects 9i OLAP Access
• Business Objects 9i OLAP
access advantages
• Resolve relational view
challenges
• Fully leverage 9i OLAP
server side calculations
and create custom local
calculation
• Integrate both 9i OLAP
and 9i relational data
Slide 30 - - Copyright © 2003 Business Objects SA - All Rights Reserved
Slide 31 - - Copyright © 2003 Business Objects SA - All Rights Reserved
Works with all Business Objects clients
Slide 32 - - Copyright © 2003 Business Objects SA - All Rights Reserved
Summary
• Business Objects and Enterprise 6
• Enable end user autonomy with IT control
• Business Objects and Oracle
• Excellent integration
• Business Objects and 9i OLAP
• Performance
• Calculations
• Integrate OLAP and relational
Slide 33 - - Copyright © 2003 Business Objects SA - All Rights Reserved