Transcript Noetix BI/DW SIG Presentation, November 2003

Using Oracle BI
with Oracle E-Business Suite
Andy Donovan and Daryl Orts
Noetix Corporation
Agenda
•
•
•
•
•
•
Introduction
Overview of Oracle BI
Integrating Oracle BI with Oracle EBS
Product Demonstration
Summary
Q&A
Agenda
•
•
•
•
•
•
Product Demonstration
Introduction
Overview of Oracle BI
Integrating Oracle BI with Oracle EBS
Summary
Q&A
Product Demonstration
About Noetix
• Oracle BI solution experts since 1994
• Offices in North America, Europe and South Asia
• Certified with all leading BI Platforms
• 2007 Product Awards: KMWorld, eWEEK, DMReview
• 1400+ customers globally
PARTNERSHIPS
Oracle Certified Advantage Partner
Generator for Oracle BI
Release 12 Support and Fusion Plans
Noetix / Oracle BI Migration Services
Noetix / Oracle PeopleSoft Agreement
Noetix integration — Oracle on Demand
Co-developed EUL Generator for Discoverer
Launch of NoetixViews for Oracle E-Business Suite
1994
Reporting Requirements
Change
Over
Time
Relationship
Over 14
Years
Components of Oracle BI
Oracle BI Architecture
Oracle BI Interactive Dashboard
Interactive pure Web dashboards that
display personalized information to
help guide users in decision making
Oracle BI Answers
A query and analysis tool that works
against a logical view of information
from multiple data sources in a pure
Web environment
Oracle BI Publisher
A reporting engine capable of
generating reports from multiple
data sources in multiple formats
via multiple delivery channels
Oracle BI Server
A query and analysis server that
integrates data via query
federation capabilities from
multiple relational, unstructured,
OLAP, and pre-packaged
application sources
OBI EE Plus does NOT include Oracle’s BI Applications. Those are separate products,
with separate pricing and additional implementation costs.
Meeting Reporting Needs with Oracle
Oracle BI Suite
Oracle Discoverer
Operational
Tactical
Strategic
Present day
What is happening now ?
Live transactional reporting
History and short to medium term
Ad hoc reporting, Why ?
Management & statutory reporting
Long term
What will happen ?
KPIs, Long term plans
Scorecards,Dashboards
OLTP RDBMS
Data Warehouse, Data Mart
Meeting Reporting Needs with Oracle
Oracle BI Suite
Oracle Discoverer
Operational
Operational
Tactical
Tactical Strategic
Strategic
Present day
What is happening now ?
Live transactional reporting
History and short to
History and short to medium
termterm
medium
Ad hoc reporting, Why ? Ad hoc reporting
Management & statutory reporting
Why ?
Long term
Long term
What will happen KPIs
?
KPIs, Long term plans
Scorecards
Scorecards,Dashboards
Dashboards
OLTP RDBMS
OLTP RDBMS
Data Warehouse, Data Mart
Data Warehouse
Data Mart
Oracle BI and Noetix
Operational
and Tactical
reporting
Tactical and
Strategic reporting
Direct
Access
to
Source
Data
BI Answers
Dashboards
BI Publisher
Data Warehouse
Direct
access
to source
data
ETL
NoetixViews
for Oracle
Oracle EBS
Oracle
Siebel
SAP
EDW
People
Soft
Federated Data Sources
KEY POINT: You don’t have to wait until you build a
data warehouse to get reporting value from Oracle BI
Other
Using NoetixViews with Oracle BI
How Noetix views work
Oracle database tables
HZ_CUSTOMERS
Noetix view of
the database
Order Lines
ATO Flag
OE_ORDER_HEADERS_ALL
PA_PROJECTS_ALL
PA_TASKS
OE_ORDER_LINES_ALL
MTL_SYSTEM_ITEMS
MTL_SYSTEM_ITEMS_TL
Booked Date
Customer
Customer No.
Item
Item Desc.
Line Status
Open Quant.
Order No.
Order Quant.
Project
Quantity
Organization
 Ad hoc query
 Report
 Extraction
Orders
Order No.
Customer
Customer No.
Booked Date
Order Quant.
Open Quant.
Selling Org.
How reports are protected
during upgrades
Oracle changes the database...
HZ_PARTIES
HZ_CUST_ACCOUNTS
Noetix remaps
the view…
Order Lines
ATO Flag
OE_ORDER_HEADERS_ALL
PA_PROJECTS_ALL
PA_TASKS
OE_ORDER_LINES_ALL
MTL_SYSTEM_ITEMS
MTL_SYSTEM_ITEMS_TL
Report
doesn’t
break
Orders
Order No.
Booked Date
Customer
Customer No.
Item
Item Desc.
Line Status
Open Quant.
Customer No.
Order No.
Order Quant.
Open Quant.
Project
Quantity
Organization
Customer
Booked Date
Order Quant.
Selling Org.
NoetixViews for Oracle EBS and
PeopleSoft Enterprise
Oracle E-Business Suite (10.7, 11i, 12)
Financials
General Ledger
Payables
Receivables
Assets
Financials Interface Tables
Discrete Manufacturing
Bill of Materials
Work in Process
Inventory
Master Scheduling/MRP
Cost Management
Procurement
Purchasing
Process Manufacturing
Product Development
Product Planning
Product Execution
OPM Financials
OPM Inventory
Order Management
Order Management
Human Resources
Human Resources
Advanced Benefits
Payroll - US Legislation
Payroll - Canadian Legislation
Payroll - Australian Legislation
Payroll - UK Legislation
PeopleSoft Enterprise (8.9)
Human Resources
Base Benefits
Base Compensation
Labor Administration
Workforce Administration
Advanced Benefits (late 2008)
Payroll (late 2008)
Enterprise Asset Management
Enterprise Asset Management
Service
TeleService
Install Base
Depot Repair
Field Service
Projects
Project Costing
Project Billing
Project Manufacturing
Project Manufacturing
Grants
Grants Proposal
Grants Accounting
Advanced Planning and Scheduling
Advanced Supply Chain Planning
EBS Administration
Application Object Library
Noetix Search
Browser-based application to access the
Noetix Business Glossary
•
Familiar UI paradigm
•
Structural organization
Filter by Oracle Applications
organizational details
Noetix Generator for Oracle BI
Oracle E-Business Suite
UDML
Generate object
definitions
Export UDML
NoetixViews
RPD
(Repository
Model)
Oracle
BI Server
Convert UDML to RPD
Why our Customers are Successful
Richest, Deepest Application Content

– Business views that pick up configuration
End User Independence
– Ease of use – auto-generated documentation
Automate Administration Tasks
– Automatically generate Oracle BI models
Change Management
– Upgrade protection
Faster Time to Deployment
– Models are completely generated in minutes
History of Success in Oracle Customers
– 1400+ Successful Customers





Thank you
for attending
[email protected]
[email protected]