Disco2OBIEE_LiveIn7Days_PittOAUG
Download
Report
Transcript Disco2OBIEE_LiveIn7Days_PittOAUG
Migrating Discoverer to OBIEE,
and getting OBIEE Live in 7 Days
Mike Hartmann, Regional Sales Manager
[email protected]
Agenda
Introductions
Sunsetting Discoverer, and your Options
Transactional versus Analytical Reporting
Where does OBIEE fit? (and REALLY fit?)
And what about those Discoverer Workbooks?
Choices for transactional reporting
Why EiS?
Summary
EiS Overview
Founded in 2001
Privately owned
Oracle Platinum Partner and ISV
International presence – US, UK
and India
•
Distribution partners globally
Resources
• Atlanta with over 60
• Hyderabad with over 80
Global customers – exceeding 120
Partnerships–Oracle, Deloitte etc.
Sunsetting Discoverer, and your Options
Discoverer 11g Premier Support – June 2014
Extended support through June 2017
What’s the direction of your organization
BI Publisher
Microsoft Excel
OBIEE
How would I move from 11.5.10.2 to say R12?
BI Publisher and Excel
BI Publisher
Development time & skills
Ad-hoc capability?
End user access?
Microsoft Excel
End users love it
No security
Manual reporting
Analytical Reporting
Transactional Reporting
Financials
SCM
Projects
CRM
Manufacturing
OBIA – BI Apps
Common Enterprise Information Model
Oracle Business Intelligence Foundation
FDM / FDQM
HCM
Analytical Reporting
ODI / ERPi
Oracle Data Integrator (ODI)
Informatica
Analytical & Transactional Reporting
Planning/Essbase – HFM/FCM
Synchronize Dimensions and Metrics
Hyperion Business Intelligence Foundation
Reporting - Utilization and Audiences
Strategic
Analytical
Reporting
Transactional
Reporting
Query
Drilldown
Forecasting
Dashboards,
Scorecards, &
KPIs
&
Statistical
Analysis
Analytical
Reporting
Predictive
Analytics
&
Optimization
Support
Transactional
Reporting
& Alerts
Standard
Reports
& Ad Hoc
Reports
Operations
•
Business Intelligence – Getting the Right Information to the Right People at the Right Time
•
Transactional versus Analytical reporting is typically an 80/20
• 80% of reports keep your lights on
• 20% of reports help you plan and strategize
Where does OBIEE fit? (and REALLY fit?)
Strategic
In the next 5 years
High level – CEO, CFO etc.
Planned (in support of strategic)
This year and next year
Senior Mgmt – VPs etc.
Operational
Today and yesterday
Line level Mgmt – Directors etc
Where Does OBIEE REALLY Fit?
OBIEE
Oracle Discoverer
Operational
Planned
Strategic
Transactions, Transactions, Transactions
Summary
Transactional System
Warehouse
What does OBIEE need to go live?
OBIEE
Operational
Planned
Strategic
Metadata, Schema, Views – EUL, Universes, Models, Star Schema etc.
Transactions, Transactions, Transactions
Transactional System
Summary
Warehouse
EiS provides what OBIEE needs for EBS
Oracle
Apps
Data
EiS
Business
Views
RPD
Over 1,250 EiS Standard Reports
OBIEE
What does OBIEE need then?
What does OBIEE need then?
What about those Discoverer Workbooks?
Discoverer Workbook Utility
Discoverer
OBI
EiS Staging Area
•
Workbook
EiS
Converter
Export
•
•
•
•
Views
Joins
Components
LOVs
Comments
(if needed)
Import
Answers
Create
RPD File
View
www.eistech.com
EiS Metadata
End user operational reporting
EiS - Choices for transactional reporting
Addresses ad-hoc
reporting needs and
provides configured
metadata (views) and
ready to use reports
for Oracle EBS
OBI content, ready to
use answers and
dashboards for
ad-hoc and real time
transactional reporting
for Oracle EBS
Enables you to run
reports from Oracle
EBS in Excel
securely while still
maintaining all your
formatting when
refreshing
Enables GL users
to replace FSGs
with Excel with
almost unlimited
drill down to any/all
sub ledgers
EiS eXpress
www.eistech.com
End user operational reporting
XL Connect
www.eistech.com
End user operational reporting
EiS/Oracle Integrated Architecture
Source
Business Layer
Report Layer
Presentation Layer
eXpress
Report Server
E-BUSINESS SUITE
11i/R12x
Configurations
•
•
•
•
•
•
•
DFF
KFF
EIT
SIT
ORG
OU
Ledgers
Metadata
(Configured)
• Views
• Reports
• Security
• Datamarts
o GL
o Payroll
o Projects
OBIEE
RPD
EiS OBI
Generator
EBS Database (XXEIS)
www.eistech.com
• Analysis
• Dashboards
Enterprise
Edition
SERVER
End user operational reporting
Why EiS?
Architecture - 100% Oracle
extension of Oracle EBS
based on your existing:
hardware
technology stack
transactional system
configuration and setups
utilizes Oracle Applications security
IT can support EiS using existing skill-sets
complete and mature EBS reporting solution
OA Framework – Fusion Middleware
Complimentary to OBIEE
Why EiS?
Coverage and Configuration
•
•
Modules – R11.x, R12.x and beyond..........
Financials – GL, AP, AR, FA, iExp and CM
Projects – Costing, Billing, Management, OTL and Grants
HCM – HR, PAY, OTL, OAB, iRec, IC, CWB and OLM
Supply Chain – PO, INV, iProc and OM
CRM – Sales and Marketing
Service – Install Base, Depot Repair and Service Order
Manufacturing – Discrete, Process, Quality and ASCP
Implementation Specific Content
discovery of Sets of Books (Ledgers in R12), OU’s & Orgs
auto-detection of all DFF’s, KFF’s, EIT’s & SIT’s
complete online documentation with training exercises
over 1,250 production ready reports
fully supported and upgradeable to any version seamlessly
EiS Customers – 100% Retention
EiS Technologies
Oracle EBS and technology experts since 2001
Oracle Certified Partner and ISV
Oracle EBS implementation experts
More than just a software company
eXpress Reporting Solutions
Fusion implementation services
OBIEE implementation services
Oracle EBS implementation services
R12 assessments and upgrades/re-implementations
Managed Services
Summary
There is life outside Discoverer
Several options to select from for
transactional reporting needs
OBIEE, BI Publisher and Excel all have a
place
Maintain investment from Discoverer in
OBIEE or EiS eXpress
Intrigued??? Special Offer!!!
Book a demo with us by March 21st
Receive a 4 hour BI assessment at NO
CHARGE!
www.eistech.com
End user operational reporting
Questions???
Mike Hartmann
[email protected]
Thank you
@EiSTechnologies
973-479-6022