Using Oracle BI Suite EE Plus

1
Using Oracle BI Suite EE Plus  with Oracle
E-Business Suite   
Joe Dahl Product Specialist Noetix Corporation
2
Agenda

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

3
About Noetix

• Oracle BI solution experts since 1994
• Offices in North America, Europe and South Asia
• Certified with all leading BI Platforms
• Recent Product Awards KMWorld, eWEEK, DMReview
• 1400 customers globally

PARTNERSHIPS
4
Oracle Certified Advantage Partner
Noetix integration OBI EE
R12 and Future Development Plans
Noetix/Oracle PeopleSoft Agreement
Noetix integration Oracle Demo Environments
Noetix integration DBI Designer
Noetix integration Oracle on Demand
Co-developed Noetix Generator for Discoverer
1994
Reporting Requirements Change Over Time
5
Components of Oracle BI
6
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.
7
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
8
Meeting Reporting Needs with Oracle
9
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
10
Using NoetixViews with Oracle BI
11
How Noetix views work
Oracle database tables
12
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
13
Information About Your Setup
14
Information About Your Setup
15
NoetixViews Coverage
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
Product Demonstration
19
Oracle BI administrators and users benefit
immediately
Administrators
Automatically creates Enterprise Information Model all 3 layers
Automatically populates publishes NoetixViews details into the model
Automatically creates facts and dimensions from relational model
End Users
Descriptive NoetixViews content
Intuitive organization of subject areas
Predefined joins and view relationships
20
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
?
?
?
?
?
21
THANK YOUfor attending

• Joe Dahl, Product Specialist
• joe.dahl_at_noetix.com