<Insert Picture Here>
Oracle Business Intelligence
Agenda
Business Intelligence Overview
• Oracle Discoverer
• Daily Business Intelligence
• Oracle Business Intelligence EE
• Fusion Intelligence for E-Business Suite
• BI Publisher
• Q&A
A Little Bit of History…
Discoverer
BIS
Embedded Data Warehouse
Transaction data Information
Meta data
EDW
DBI
Oracle Application Reports
Transaction Reporting / Publishing
Daily Business Intelligence
KPI’s, Measures
Apps Users
Apps/Power Users
Business Analysts
Executives / Managers
Job
Tool
Operational Strategic
System Users Execs
Managers/
Analysts
Executives / Strategists
Financial Users
FSG, ADI
Financial Reporting Oracle Discoverer
AdHoc Reporting
Oracle Provides Business Insight
Oracle Business Intelligence
EE Analytics
Oracle Business Intelligence
EE Analytics
Oracle Business Intelligence
EE Analytics
Pervasive use
Analysts
Real-time, predictive data
Historical data
Insight-driven business process
optimization
Reporting results
To:
From:
Unified infrastructure & prebuilt
analytic solutions
Analytic tools
The Evolving Role of BI
Unified, enterprise view
Fragmented view
Agenda
Business Intelligence Overview
• Oracle Discoverer
• Daily Business Intelligence
• Oracle Business Intelligence EE
• Fusion Intelligence for E-Business Suite
• BI Publisher
• Q&A
Oracle Discoverer
Oracle Business Intelligence Standard Edition (OBI SE)
Make effective decisions by investigating operational
details
• Ad Hoc analysis tool
• Integrated with Oracle Application
security
• Pre-built reporting data definitions
• Integrates to Oracle Portal
• Wizard-based Report Development
• Supports OLAP Analysis
Discoverer Plus OLAP
Agenda
Business Intelligence Overview
• Oracle Discoverer
• Daily Business Intelligence
• Oracle Business Intelligence EE
• Fusion Intelligence for E-Business Suite
• BI Publisher
• Q&A
What is Daily Business Intelligence?
Out-of-the-Box, Integrated Management Reporting for the Oracle
E-Business Suite:
– Oracle Dashboard based pages
– Key performance indicator portlets
– Management summary portlets
– Ability to drill-down to reports
An embedded management reporting system for the E-Business
Suite, without requiring a separate data warehouse, resulting in very
fast implementation and dramatically lower costs!
Oracle Daily Business Intelligence (DBI)
Easy-To-Use Dashboards Within E-Business Suite
•
Role Based Dashboards•
Leverages EBS Infrastructure and Materialized Views•
Drill Directly to Transactions from Summaries•
Implement Quickly•
Fastest Path toInformation from EBS
•
Part of EBS “Rapid Install”•
No Training RequiredBefore
DBI
Agenda
Business Intelligence Overview
• Oracle Discoverer
• Daily Business Intelligence
• Oracle Business Intelligence EE
• Fusion Intelligence for E-Business Suite
• BI Publisher
• Q&A
Problem: Various BI Tools and Data
Sources
Ad-hoc Analysis Reporting &
Publishing Interactive
Dashboards
OLTP & ODS
Systems Data Warehouse
Data Mart SAP, Oracle PeopleSoft, Siebel,
Custom Apps
Files Excel
XML
Business Process
Disadvantages:
ü Different user
experience across products & tools
ü Disperate metadata, shared services &
data stores
ü Multiple BI systems to learn and maintain
DW & OLAP Tools
Logical Layer: Metadata, Data Stores, ETLs, EULs
OLTP & ODS
Systems Data Warehouse
Data Mart SAP, Oracle PeopleSoft, Siebel,
Custom Apps
Files Excel
XML
Business Process
Advantages:
ü Consolidate and standardize BI tools ü Seamless user
experience across products
ü Unified metadata and shared
services
Oracle BI Suite Enterprise Edition
Enhancing Analytic Applications
Oracle BI Enterprise Edition: Leading Technology
Oracle BI Server
Proactive Detection and Alerts
Disconnected Analytics Ad-hoc
Analysis MS Office
Plug-in Reporting &
Publishing Interactive
Dashboards
Multidimensional Calculation and Integration Engine Intelligent Caching Services
Simplified Business Model and Abstraction Layer
Intelligent Request Generation and Optimized Data Access Services
Pipeline Analysis Triangulated
Forecasting Sales Team Effectiveness
Up-sell / Cross-sell Discounting
Analysis Lead Conversion
Receivables / Payables Analysis
Customer Profitability
Product Profitability Regulatory Compliance Expense Management
Cash Flow Analysis Churn
Propensity Customer Satisfaction
Resolution Rates Service Rep Effectiveness
Service Cost Analysis
Service Trends
Campaign Scorecard Response
Rates Product Propensity Loyalty and
Attrition Market Basket
Analysis Campaign ROI
Supplier Performance
Inventory Analysis Procurement
Cycle Times Inventory Availability Employee Expenses BOM Analysis
Employee Productivity Compensation
Analysis Compliance
Reporting Workforce
Profile Turnover
Trends Return on Human Capital
Leverage Prebuilt Oracle BI Applications
Built in Best Practices Across Functions and Industries
Sales Analytics
Financial Analytics
Workforce Analytics Supply Chain
Analytics Service &
Contact Center Analytics
Marketing Analytics
Travel
& Trans Auto Comms.
& Media Complex Mfg.
Consumer Sector
Energy Financial Services
High Tech
Insurance
& Health Life Sciences
Public Sector
Other Operational
& Analytic Sources
Oracle BI Suite Enterprise Edition
Prebuilt adapters:
Selected Key Entities of BI Data Model
Conformed Dimensions
§ Customer
§ Products
§ Suppliers
§ Internal Organizations
§ Customer Locations
§ Customer Contacts
§ GL Accounts
§ Employee
§ Sales Reps
§ Service Reps
§ Partners
§ Campaign
§ Offers
§ Cost Centers
§ Profit Centers
§ Date Sales
§ Opportunities
§ Quotes
§ Pipeline
Order Management
§ Sales Order Lines
§ Sales Schedule Lines
§ Bookings
§ Pick Lines
§ Billings
§ Backlogs
Marketing
§ Campaigns
§ Responses
§ Marketing Costs
Supply Chain
§ Purchase Order Lines
§ Purchase Requisition Lines
§ Purchase Order Receipts
§ Inventory Balance
§ Inventory Transactions
Finance
§ Receivables
§ Payables
§ General Ledger
§ COGS
Call Center
§ ACD Events
§ Rep Activities
§ Contact-Rep Snapshot
§ Targets and Benchmark
§ IVR Navigation History
Service
§ Service Requests
§ Activities
§ Agreements
Workforce
§ Compensation
§ Employee Profile
§ Employee Events
Pharma
§ Prescriptions
§ Syndicated Market Data
Financials
§ Financial Assets
§ Insurance Claims
Public Sector
§ Benefits
§ Cases
§ Incidents
§ Leads
Modular Data Model includes:
~150 Fact Tables
~200 Dimension Tables
~16,300 Data Elements
End User Products
Enterprise Edition
Oracle Delivers
• Guided experience leads user from insight to action
• Intuitive and interactive dashboards/scorecards
• Personalized, function-specific and role-based
Oracle Interactive Dashboards
Oracle Answers
• Ad-hoc data exploration
• True business user self sufficiency
• Create, modify and author analysis, pivots and dashboards
• Dynamic problem/opportunity detection and notification
• Automated analytic workflows and processes
• Tailored delivery for wide range of mobile devices
Oracle BI Publisher
• Schedule & distribute enterprise-class reports
• Sophisticate “pixel-perfect” report layout controls
Oracle Analytic Applications
Adapting to the needs of Operational Users
Peoplesoft Enterprise/JDE Oracle
eBusiness Suite Oracle
BI Applications
• DBI
• Materialized Views
• Easy
Implementation
• Oracle BI EE
Today
• EPM
• Operational
Level Reporting
• Oracle BI EE
• Additional horizontal and industry content
• Continued investment in all product families
• New analytic subject areas and industry specific applications
• Single Suite of integrated BI & CPM applications
• Pre-Integrated with EBS, PSFT, JDE & SEBL
• Embedded within transactional applications
Future
• BI Applications
• Multi-Source
• Cross Enterprise Insight
• Oracle BI EE
Leverage Oracle Technology Today
Pre-Packaged Semantic Objects
Pre-Packaged Dashboards
Pre-Packaged Reports
E-Bus Suite PeopleSoft Siebel
SAP Packaged
ETL Maps
Siebel Analytic
Apps PSFT EPM
EBS DBI
Custom Schema In-Place Schema Warehouse Schema Pre-Packaged Applications
Oracle
Server BI
Agenda
Business Intelligence Overview
• Oracle Discoverer
• Daily Business Intelligence
• Oracle Business Intelligence EE
• Fusion Intelligence for E-Business Suite
• BI Publisher
• Q&A
What is Fusion Intelligence for E-Business
Suite
UNIFIED SEMANTIC MODEL
E-Business Suite
CFO, VP of Finance Controller,
Financial Manager Line
Managers
Ad-Hoc Analytics Interactive
Dashboards
Alerts and notifications
FIN SCM PROC HCM CRM
DBI Base Summaries
Off-line Analytics
Other
Roles-based content supported throughunified security model
Market-leading BI tool provides rich end-user experience with
dashboarding, ad hoc analysis, alerts and off-line analytics
Unified semantic model facilitates cross-pillar analytics
Reusable, pre-summarized data in DBI enables enhanced
performance
Delivered connection to EBS data with capability to source data from other sources
Before
DBI
Value Proposition : Flexible, Extensible BI Platform
that is open to multiple data sources
Fusion Intelligence EBS Edition
Pre-Packaged Repository Scope
• Order to Revenue
• Order Fulfillment and Shipping
• Manufacturing (Process and Discrete)
• Inventory (Process and Discrete)
Financials Intelligence
• DBI Workforce Activity and Deployment
• DBI Compensation Salary Summarization
• DBI Leave and Absences
• HCM EUL Recruitment Pipeline
• HCM EUL Recruitment Vacancies
• General Ledger
• AP Expenses (GL)
• AR Revenue (GL)
• GL Activity
• Budget
• Accounts Payable
• AP Invoices
• AP Invoices Aging (Due & Past)
• AP Payments Schedule
• Accounts Receivable
• AR Adjustments
• AR Payments Schedule
• AR Receipts
• AR Invoices
• AR Aging Receivables
• Sales Credits
• Compliance
• Sales Opportunity
• Sales Pipeline
• Sales Forecasting
• Service
Sales & Service Intelligence
Supply Chain & Order Mgmt Intelligence
Human Resources Intelligence
• Procurement Management
• Supplier Management
Procurement Intelligence
Scalable and Extensible Business
Intelligence
• Integration with Market-leading Oracle BI Enterprise Edition (OBIEE)
-
Oracle Answers
• Author custom Dashboards, Reports, KPIs, Graphs, Tables and Links
Dashboard Editor
• Add, Rearrange, Hide, or Rename Dashboards, Reports, KPIs, Graphs, Tables and Links
Oracle Delivers
• Receive alerts based on events, accompanied by Guided Navigation Paths
Guided Navigation & Action Links
• Analytic Workflows
• Guided Navigation and Conditional Navigation links
• Checks for specific conditions and displays (or not) a dashboard section, or a navigational link to either a report or a dashboard
• Action Links
• Direct navigation from record to transactional while maintaining context
Unified, Common Business Semantic
Model
Seamless Integration with OLTP/
Transactional Applications -
EBS-integrated Security Model
• Launch Oracle DBI EE dashboard from Application Navigator
• Shared responsibilities between Oracle EBS and Oracle DBI EE
• Sign in only once in EBS
DBI Base Summaries and MVs available for Ad-hoc Query
• Data resident in OLTP Database
Detail level Data
• Incredibly rich data model available for Oracle EBS
Guided Drill into OLTP to View Detail
Integrated Security
• Oracle Application Framework
integration –
Launch Oracle BI EE dashboard from Application
Navigator
• Shared
responsibilities between Oracle EBS and Oracle BI EE
• Sign in only once in EBS
Key Business Benefits
Oracle BI EE with EBS, PS EPM, SBA
• Tight Integration: Seamless interaction with Oracle E-
Business Suite for optimal user experience
• menu, data security, single sign-on, seamless drills, conformed
dimensions, uniform business definitions, etc.
• Guided Navigation: Assist in discovering root cause
and forming corrective action;
• Lower TCO: Pre-built data extractions, transformations,
and logical User Layer
• Extensibility : Market leading BI technologies for
superior configurability and flexibility
• Embedded Intelligence: Empower users at point of
decision making
Agenda
Business Intelligence Overview
• Oracle Discoverer
• Daily Business Intelligence
• Oracle Business Intelligence EE
• Fusion Intelligence for E-Business Suite
• BI Publisher
• Q&A
BI Publisher
High Quality Enterprise Reporting
Integrate Out-of-the-Box with Oracle Applications
Templates
BI Publisher
Oracle Applications
CRM ESA FMS HCM SCM
Output Formats Data Sources
Any XML Data Source
PDF RTF
Business User
Publishing Engine
XML
• Printer
• Fax
HTML XML
Letters Fund
Transfers Online
Paychecks Order
Confirmations
Bills Government
Grant Forms
Destination
EDI Excel
BI Publisher
Business Users Format and Deliver Documents
OBI EE
Using BI Publisher with EBS:
6 easy steps to convert an EBS Report
1. Setup Concurrent Program to generate XML output
2. Save the XML output – use it to build your Report Layout
3. Use desktop tool to build your template using Template Builder
4. Setup BI Publisher Data Definition in Oracle Applications
5. Setup BI Publisher Template in Oracle Applications
6. Now, run concurrent job and get your BI Publisher report!
It ’ s that easy…
BI Publisher with OBI EE
• BI Publisher for Advanced
Reporting & Formatting
• BI Server provides the
semantic layer (logical layer)
as a Data Source for BI
Publisher
• BI Publisher reports can be
added to Dashboards
• OBI EE can be used to
create the XML
• Integrated Security
BI Publisher with OBI EE
Q & A
For More Information:
www.oracle.com/solutions/business_intelligence/index.html Fusion Intelligence for E-Business Suite: