Oracle BI/XML Publisher Oracle DBI/Discoverer Hyperion Essbase OBIEE

1. Oracle’s Reporting Strategy • Oracle BI/XML Publisher • Oracle DBI/Discoverer • Hyperion Essbase • OBIEE

2. Oracle’s Reporting Strategy • Agenda: • What is it and how is it used • Strengths and Weaknesses • Synergies and redundancies with other tools • Screenshots Benefits

3. Oracle’s Reporting Strategy • Oracle BI/XML Publisher • An enterprise level reporting solution to author, manage, and deliver all types of highly formatted documents eliminating the need for costly point solutions • Allows power users to easily design report layouts using familiar desktop tools. • Separates data from presentation • Enables to query or accept data from multiple sources • Helps in publishing one document to multiple output formats and destinations

4. Oracle’s Reporting Strategy • Oracle BI/XML Publisher • Mainly used for Static Reporting • Richly Formatted Reports • Financial Statements • Checks, Labels, etc • Advanced Charting • Report Layout templates can be designed using MS Word, Excel or Adobe Acrobat • Supports creation of layouts in 185 languages

5. Oracle’s Reporting Strategy Data Source Layout Output Delivery PDF Email Oracle, SQL Server RTF Printer HTML Oracle 11i, PeopleSoft, SAP, Siebel Excel Fax XML Publisher XML XSL WebDAV Templates Oracle Reports, PL/SQL, Java, Perl, etc EDI EFT WWW Web Services

6. Oracle’s Reporting Strategy • Oracle BI/XML Publisher • Built on Open standard technologies • Can be deployed in any J2EE container • BI Publisher is used in Advanced reporting in BI EE Plus • Already integrated with Oracle eBusiness 11i and R12, Peoplesoft, Siebel,etc • Integrated with Discoverer to create formatted reports with data from Discoverer worksheets

7. Oracle’s Reporting Strategy

8. Oracle’s Reporting Strategy

9. Oracle’s Reporting Strategy

10. Oracle’s Reporting Strategy

11. Oracle’s Reporting Strategy • Oracle Discoverer • Discoverer is an intuitive ad-hoc query, reporting, analysis, and Web-publishing tool that empowers business users to access information from various systems • Provides powerful analytical functionality such as dimensions, data slicing, drilling to details, etc • Flexibility to change report layouts • Spreadsheet functionality • Enables business users to create their reports on the fly.

12. Oracle’s Reporting Strategy • Oracle Discoverer • Provides management of infrastructure • EUL (Presentation Layers) • Business areas (Access Control) • Folders, Conditions, Joins, etc • Security (Users and Responsibilities) • Enables creation of multiple worksheets (tabular, crosstab) • Place items from folders on page, top or side • Apply conditions, parameters to refine the reports • Create calculations, add charts, colors without any need for coding • Ability to share or unshare workbooks with multiples users • Easily export to excel, html, pdf, xml, csv, etc

13. Oracle’s Reporting Strategy • Oracle Discoverer • Discoverer has evolved into internet enabled application and is integrated with Oracle DB and Fusion middleware. • Latest release of Discoverer provides integration with OBIEE. • Discoverer Web Services APIs help to integrate with business systems and processes using SOA.

14. Oracle’s Reporting Strategy

15. Oracle’s Reporting Strategy

16. Oracle’s Reporting Strategy

17. Oracle’s Reporting Strategy • Oracle Essbase: • Essbase offers powerful business analytics • Provides superior calculation power • Provides extensive financial and time intelligence • Enables optimized storage. • Enables creation of Enterprise scale forward looking applications • Provides richest business user experience and best custom analytic environment

18. Oracle’s Reporting Strategy • Oracle Essbase: • Essbase offers multi dimensional views • Essbase offers single design environment unifying modelling of many sources such as Structured Relational, Flat files, XML files, EPM Architect dimensions, OBIEE • Enables reuse of hierarchies, metrics, cub schemas at a granular level • Offers Drill anywhere functionality to relational, OBIEE, URL, Essbase, etc

19. Oracle’s Reporting Strategy • Oracle Essbase: • Provides Web Analysis Reports • Web based • Interactive • Flexible Displays • Calculations • Provides Financial Reporting • Web based • Highly formatted • Interactive • Report Books • Batch Distribution

20. Oracle’s Reporting Strategy

21. Oracle’s Reporting Strategy

22. Oracle’s Reporting Strategy

23. Oracle’s Reporting Strategy

24. Oracle’s Reporting Strategy

25. OBIEE Plus • Oracle business intelligence suite enterprise edition plus is a comprehensive suite of enterprise BI products that delivers a full range of analysis and reporting capabilities. • Featuring a unified, highly scalable, modern architecture, Oracle BI EE Plus provides intelligence and analytics from data spanning enterprise sources and applications empowering the largest communities with complete and relevant insight. • Provides powerful analytical functionality such as dimensions, data slicing, drilling to details, Navigate to different subject areas etc. • Oracle BI EE Plus also bundles key Oracle Hyperion reporting products for integrated reporting with Oracle Hyperion financial applications.

26. OBIEE plus • Can report from several data sources – flat files, relational and multi-dimensional sources. • Has several unique features not readily available in other BI platforms – disconnected analytics, analytic workflows, etc.

27. OBIEE Plus Components • Server, client and web-based interface • Oracle BI Server • Oracle Presentation Server • Oracle Answers • Oracle BI Publisher • Interactive Dashboards • Oracle BI Delivers • Oracle BI Administration • Others: • Disconnected Analytics • MS Office Plugins • Web Service connectivity • Tightly integrated

28. Oracle’s Reporting Strategy • OBIEE Plus Benefits • Comprehensive BI functionality built on a unified infrastructure—Includes interactive dashboards, full ad hoc queries and analysis, proactive intelligence delivery and alerts, enterprise and financial reporting, online analytical processing (OLAP) analysis and presentation, high-volume production reporting, real-time predictive intelligence, disconnected analytics, as well as integration with Microsoft Office. • Pervasive insight to everyone, everywhere—Provides relevant insight to everyone, not just analysts. All levels of the organization can see information optimized for their role. • Unified business model—Built on an enterprise information model that unifies metadata across the Oracle BI tools and analytical applications for the lowest TCO. • Hot-Pluggable BI infrastructure—Integrates with any data source, extraction, transformation and load (ETL) tool, major business application, application server, security infrastructure, portal technology, other front-end and analytical tools, and databases including IBM DB/2, Teradata, Microsoft SQL Server; SAP Business Information Warehouse (BW), Microsoft Analysis Services; flat files; XML data; and unstructured data.

29. Oracle’s Reporting Strategy • OBIEE Plus Architecture

30. Oracle’s Reporting Strategy • OBIEE Plus Dashboards

31. Oracle’s Reporting Strategy • OBIEE Plus Administrator