1 / 31

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

Oracle’s Reporting Strategy. Oracle BI/XML Publisher Oracle DBI/Discoverer Hyperion Essbase OBIEE. Oracle’s Reporting Strategy. Agenda: What is it and how is it used Strengths and Weaknesses Synergies and redundancies with other tools Screenshots. Benefits.

wednesday
Download Presentation

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

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  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

More Related