Obiee

Oracle Business Intelligence Suite Enterprise Edition Plus – Technical Overview
An Oracle White Paper November 2007

NOTE:

The following is intended to outline our general product direction. It is intended for information purposes only and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality and should not be relied upon inmaking purchasing decisions. The development, release, and timing of any features or functionality described for Oracle’s products remain at the sole discretion of Oracle.

Oracle Business Intelligence Suite Enterprise Edition Plus – Technical Overview

Page 2

TABLE OF CONTENTS

NOTE ........................................................................................ 2 TABLE OF CONTENTS............................................................ 3 ENABLING THE INSIGHT DRIVEN ENTERPRISE .................. 5 PRODUCT OVERVIEW ............................................................ 6 OBIEE DESIGN PRINCIPLES .................................................. 8 ORACLE BI SERVER ............................................................. 10 Query Parsing and Compilation.............................................. 11 Code Generation ..................................................................... 12 Parallel Execution Engine ....................................................... 12 Information Reliability .............................................................. 13 Accessing Oracle BI Server Information.................................. 13 Oracle BIPRESENTATION SERVICE.................................... 13 Features of Oracle BI Presentation Service ............................ 14 ORACLE BI ANSWERS .......................................................... 16 Using Oracle BI Answers......................................................... 17 Features of Oracle BI Answers ............................................... 17 Physical Data StorageIndependence ..................................... 18 Complex Business Measures .................................................. 19 ORACLE BI INTERACTIVE DASHBOARD............................. 19 Using Oracle BI Interactive Dashboard ................................... 20 Features of Oracle BI Interactive Dashboard .......................... 21 Guided Analytics with Oracle BI Interactive Dashboards........ 21 ORACLE BI PUBLISHER........................................................ 22 Using Oracle BI Publisher ....................................................... 22 Features of Oracle BI Publisher .............................................. 24 Oracle BI Briefing Books ......................................................... 25 ORACLE BI DELIVERS.......................................................... 25 Using Oracle BI Delivers ......................................................... 26 Features of Oracle BI Delivers ................................................ 26 Oracle BI Delivers and Oracle BPEL Process Manager.......... 27 Oracle BI Office Plug-In........................................................... 27 Features of Oracle BI Office Plug-In....................................... 28 ORACLE BI DISCONNECTED ANALYTICS........................... 29 Oracle Analytics Adapters ....................................................... 30 Mission Critical Performance, Scalability, and Reliability ........ 30

Oracle Business Intelligence Suite Enterprise Edition Plus – Technical Overview

Page 3

Highly Efficient Oracle BI Server Design................................. 31 Highly Efficient Data Sourcing and Aggregation...................... 31 Exploiting Database Facilities.................................................. 31 Connection Pooling ................................................................. 32 Query Reuse and Caching ...................................................... 32 ORACLE BUSINESS INTELLIGENCE ADMINISTRATOR..... 33...