310 likes | 796 Views
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.
E N D
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
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
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
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
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
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.
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
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.
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
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
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
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.
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.
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
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.
Oracle’s Reporting Strategy • OBIEE Plus Architecture
Oracle’s Reporting Strategy • OBIEE Plus Dashboards
Oracle’s Reporting Strategy • OBIEE Plus Administrator