Migrating Discoverer to OBIEE, and getting OBIEE Live in 7 Days

1. MigratingDiscoverer to OBIEE, and getting OBIEE Live in 7 Days Mike Hartmann, Regional Sales Manager mike.hartmann@eistech.com

2. 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

3. 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.

4. 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?

5. 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

6. Analytical & Transactional Reporting Analytical Reporting Analytical Reporting Transactional Reporting HCM SCM CRM Financials Projects Manufacturing FDM / FDQM ODI / ERPi Oracle Data Integrator (ODI) Informatica OBIA – BI Apps Planning/Essbase – HFM/FCM Synchronize Dimensions and Metrics Common Enterprise Information Model Hyperion Business Intelligence Foundation Oracle Business Intelligence Foundation

7. Reporting - Utilization and Audiences Analytical Reporting Analytical Reporting Transactional Reporting Transactional Reporting • 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

8. 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

9. Where Does OBIEE REALLY Fit? OBIEE Oracle Discoverer Operational Planned Strategic Transactional System Warehouse Transactions, Transactions, Transactions Summary

10. OBIEE What does OBIEE need to go live? Operational Planned Strategic Metadata, Schema, Views – EUL, Universes, Models, Star Schema etc. Transactional System Warehouse Transactions, Transactions, Transactions Summary

11. EiS provides what OBIEE needs for EBS Oracle Apps Data EiS Business Views OBIEE RPD Over 1,250 EiS Standard Reports

12. What does OBIEE need then?

13. What does OBIEE need then?

14. What about those Discoverer Workbooks? Discoverer Workbook Utility Discoverer OBI EiS Staging Area Answers Workbook • Views • Joins • Components • LOVs • Comments • (if needed) EiS Converter RPD File Export Import Create View EiS Metadata www.eistech.com

15. EiS - Choices for transactional reporting OBI content, ready to use answers and dashboards for ad-hoc and real time transactional reporting for Oracle EBS Addresses ad-hoc reporting needs and provides configured metadata (views) and ready to use reports for Oracle EBS Enables GL users to replace FSGs with Excel with almost unlimited drill down to any/all sub ledgers Enables you to run reports from Oracle EBS in Excel securely while still maintaining all your formatting when refreshing

16. EiS eXpress www.eistech.com

17. XL Connect www.eistech.com

18. EiS/Oracle Integrated Architecture Source Business Layer Presentation Layer Report Layer • eXpress • Report Server 11i/R12x • Configurations • DFF • KFF • EIT • SIT • ORG • OU • Ledgers • Views • Reports • Security • Datamarts • GL • Payroll • Projects • EBS Database (XXEIS) • Metadata • (Configured) • OBIEE • RPD E-BUSINESS SUITE EiS OBI Generator Enterprise Edition • Analysis • Dashboards • SERVER www.eistech.com

19. 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

20. 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

21. EiS Customers – 100% Retention

22. 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

23. 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

24. Intrigued??? Special Offer!!! Book a demo with us by March 21st Receive a 4 hour BI assessment at NO CHARGE! www.eistech.com

25. Questions???

26. Thank you Mike Hartmann Mike.Hartmann@eistech.com @EiSTechnologies 973-479-6022