Using Oracle BI with Oracle EBusiness Suite

1
Using Oracle BI   with Oracle E-Business Suite  

Andy Donovan and Daryl Orts Noetix Corporation
2
Agenda

• Introduction
• Overview of Oracle BI
• Integrating Oracle BI with Oracle EBS
• Product Demonstration
• Summary
• Q A

3
Agenda

• Product Demonstration
• Introduction
• Overview of Oracle BI
• Integrating Oracle BI with Oracle EBS
• Summary
• Q A

4
Product Demonstration
5
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
6
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
7
Components of Oracle BI
8
Oracle BI Architecture
Oracle BI Publisher A reporting engine capable of
generating reports from multiple data sources in
multiple formats via multiple delivery channels
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 Interactive Dashboard Interactive pure
Web dashboards that display personalized
information to help guide users in decision making
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 Oracles BI
Applications. Those are separate products, with
separate pricing and additional implementation
costs.
9
Meeting Reporting Needs with Oracle
Operational
Tactical
Strategic
Data Warehouse, Data Mart
OLTP RDBMS
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
10
Meeting Reporting Needs with Oracle
11
Oracle BI and Noetix
Operational and Tactical reporting
BI Answers Dashboards BI Publisher
Direct access to source data
Data Warehouse
ETL
Oracle
Siebel
SAP
EDW
PeopleSoft
Other
KEY POINT You dont have to wait until you
build a data warehouse to get reporting value
from Oracle BI
12
Using NoetixViews with Oracle BI
13
How Noetix views work
Oracle database tables
14
How reports are protected during upgrades
Oracle changes the database...
HZ_CUST_ACCOUNTS
HZ_PARTIES
OE_ORDER_HEADERS_ALL
OE_ORDER_LINES_ALL
PA_PROJECTS_ALL
PA_TASKS
MTL_SYSTEM_ITEMS
MTL_SYSTEM_ITEMS_TL
15
NoetixViews for Oracle EBS and PeopleSoft
Enterprise
16
Noetix Search
Browser-based application to access the Noetix
Business Glossary

• Familiar UI paradigm

• Structural organization
• Filter by Oracle Applications
• organizational details

17
Noetix Generator for Oracle BI
UDML
Oracle E-Business Suite
Generate object definitions Export UDML Convert
UDML to RPD
NoetixViews
RPD (Repository Model)
OracleBI Server
18
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
?
?
?
?
?
19
Thank youfor attending

• Andy.Donovan_at_Noetix.com
• Daryl.Orts_at_Noetix.com