Business Objects and Oracle 9 i OLAP Jason

Business Objects and Oracle 9 i OLAP Jason Kuo Oracle. World

Topics • Introducing Business Objects and Enterprise 6 • Oracle and Business Objects product integration • Business Objects and Oracle 9 i OLAP Slide 2 - - Copyright © 2003 Business Objects SA - All Rights Reserved

Technology Leader Over a decade of constant innovation • Founded in 1990 • Worldwide presence: 80 countries • Enterprise Analytic Applications Set-Based Analysis Dual HQ: San Jose, CA / Paris, France BI Repository Semantic Layer Integrated Pivot Metadata Bridging Enterprise 6 Integrated Web BI Query From Excel Application Templates Data Integration Integrated Mobile BI BI Extranets Integrated OLAP 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 Slide 3 - - Copyright © 2003 Business Objects SA - All Rights Reserved

Blue Chip Customers Across All Industries More than 18, 000 customers bank Slide 4

Business. Objects Enterprise 6 Enterprise Analytic Applications Business Intelligence Platform Data Integration Products Slide

Data Integration The most productive DI platform on the market today • Parallel performance architecture for industrialstrength ETL Q, R, A Tools Management Dashboards Analytic Applications • A complete redesign of the user interface • Data preview and profiling within design environment • Impact analysis from sources to end user reports Custom Applications Web Data Slide 6 - - Copyright © 2003 Business Objects SA - All Rights Reserved RDBMS Data ERP Data Customer Data Legacy Data Supplier Data

Data Integration with Oracle Applications • Metadata browsing and import • Browse through the Oracle Apps organization of tables • Show table descriptions and business names • Import Oracle Apps tables by name • Types of objects supported • PK/FK relationship information • Descriptive flexfields • Key flexfields • Two-way real-time interface • Initiate an insert/update/delete request; subscribe to events Slide 7 - - Copyright © 2003 Business Objects SA - All Rights Reserved

Query, Reporting, and Analysis • Business. Objects • Integrated query, reporting, and analysis • A web-enabled full-client tool • Web. Intelligence • All the power of Windows available for the web • True thin client for extranet users • Business. Query for Excel • The power and ease of use of Business. Objects data access for Microsoft Excel users Slide 8 - - Copyright © 2003 Business Objects SA - All Rights Reserved

Information Delivery • Info. View • A business intelligence portal • Presents a secure, focused, and personalized view • Broadcast Agent • Delivery of timely and personalized information, and of business driven alerts • Schedule then publish, burst, email • Dashboards and Scorecards • Total flexibility to create dashboards that match your business needs • Provide a fast and effective way of monitoring key measures Slide 9 - - Copyright © 2003 Business Objects SA - All Rights Reserved

BI Deployment Infrastructure • Designer • Design tool to create the “semantic layer” (metadata) • Supervisor • Security and user management • Auditor • Monitor, analyze, and optimize the BI deployment. • Developer Suite • Development toolkit to customize, integrate, and extend Business. Objects Enterprise 6 Slide 10 - - Copyright © 2003 Business Objects SA - All Rights Reserved

Dashboards • Can be personalized and customized • Unlimited analytics, gauges, • Thumbnails on any page • Combine analytics from multiple applications in a single view • Easy access to key performance indicators (KPIs) • Consolidated view of the business • Receive actionable alerts Slide 11 - - Copyright © 2003 Business Objects SA - All Rights Reserved

Enterprise Analytic Applications • Packaged analytic applications that span the enterprise • An integrated suite built on the Business Objects Warehouse • Accelerates implementation time • Delivers packaged bestpractice analysis Slide 12 - - Copyright © 2003 Business Objects SA - All Rights Reserved

Topics • Introducing Business Objects and Enterprise 6 • Oracle and Business Objects product integration • Business Objects and Oracle 9 i OLAP Slide 13 - - Copyright © 2003 Business Objects SA - All Rights Reserved

Oracle and Business Objects Synergies • Oracle DB • • RDBMS 9 i OLAP 10 G Beta Express Oracle Applications Oracle Portal Oracle 9 i. AS Oracle Designer Slide 14 - - Copyright © 2003 Business Objects SA - All Rights Reserved

Oracle and Business Objects Synergies • Oracle DB • Advanced SQL functions - Ranking Cumulative Aggregate Ratio to Report Linear Regression • 10 G Beta program - Improved clustering Higher availability Enhanced business intelligence Automated systems management • Express - Ad-hoc querying and enterprise reporting on Express Multi-source data integration within one report Mobile computing—analyze data while offline Rporting, scheduling, distribution, and web publishing for Express data Slide 15 - - Copyright © 2003 Business Objects SA - All Rights Reserved

Oracle and Business Objects Synergies • Oracle Applications • 10. x - Application Object Library (AOL) Accounts Payable (AP) Accounts Receivable(AR) Bill Of Materials (BOM) Engineering (ENG) Fixed Assets (FA) General Ledger (GL) Human Resources (HR) Inventory (INV) Master Scheduling/MRP (MS/MRP) Order Entry (OE) Payroll (PAY) Project Accounting (PA) Purchasing (PO) Work In Process (WIP) Slide 16 - - Copyright © 2003 Business Objects SA - All Rights Reserved • 11. x - Payroll Projects Purchasing Work in Process Cash Management Capacity Engineering Sales and Marketing Service Order Management Shipping module

Data Integration with Oracle Applications • Metadata browsing and import • Browse through the Oracle Apps organization of tables • Show table descriptions and business names • Import Oracle Apps tables by name • Types of objects supported • PK/FK relationship information • Descriptive flexfields • Key flexfields • Two-way real-time interface • Initiate an insert/update/delete request; subscribe to events Slide 17 - - Copyright © 2003 Business Objects SA - All Rights Reserved

Oracle and Business Objects Synergies • Oracle Portal • Embed Enterprise 6 • Oracle 9 i. AS • Fully supported • Oracle Designer • Share CWM models Slide 18 - - Copyright © 2003 Business Objects SA - All Rights Reserved

Topics • Introducing Business Objects and Enterprise 6 • Oracle and Business Objects product integration • Business Objects and Oracle 9 i OLAP Slide 19 - - Copyright © 2003 Business Objects SA - All Rights Reserved

Architecture • Build from AW, OLAP engine, Relational View, flat table Slide 20 -

Business Objects 9 i OLAP Access APPLICATION • Innovative way of SQL access to 9 i OLAP Analytic Workspaces Returns data through OCI or JDBC SELECT Statement RELATIONAL ENGINE Select list and WHERE clause predicates Returns data in Row format OLAP_TABLE OLAP DML commands Aggregation and calculation Slide 21 - - Copyright © 2003 Business Objects SA - All Rights Reserved Returns data in multidimensional format MULTIDIMENSIONAL ENGINE

Business Objects 9 i OLAP Access • Business Objects 9 i OLAP access advantages • Resolve relational view challenges • Fully leverage 9 i OLAP server side calculations and create custom local calculation • Integrate both 9 i OLAP and 9 i relational data Slide 22 - - Copyright © 2003 Business Objects SA - All Rights Reserved

Access Any Data Source Databases Oracle IBM SQL Server Teradata Red Brick ODBC… Data Marts Warehouses Normalized ODS Star Snowflake… ERP, CRM OLAP Servers Local Data SAP Hyperion Essbase. Text People. Soft SAP BW Excel… Baan SQL Server Oracle Financials. Analysis Services… Siebel… Slide 23 - - Copyright © 2003 Business Objects SA - All Rights Reserved Internet HTML XML…

The Semantic Layer • The semantic layer may consist of one or more universes • Each universe is a partial representation of a database, in the form of business vocabulary Sales/Marketing Human Resources Employee Salary Benefits. . . Slide 24 - - Copyright © 2003 Business Objects SA - All Rights Reserved Sales Revenue Sales Executive Customer Product Price Order Date. . .

Business Objects Universe Graphical, easy creation of the semantic layer • Fast universe creation • In a few mouse clicks • Leverage existing metadata • Resolve data schema difficulties • Exploit DW power • Aggregate awareness Slide 25 - - Copyright © 2003 Business Objects SA - All Rights Reserved

Slide 26 - - Copyright © 2003 Business Objects SA - All Rights Reserved

Business Objects 9 i OLAP Access • Business Objects 9 i OLAP access advantages • Resolve relational view challenges • Fully leverage 9 i OLAP server side calculations and create custom local calculation • Integrate both 9 i OLAP and 9 i relational data Slide 27 - - Copyright © 2003 Business Objects SA - All Rights Reserved

Slide 28 - - Copyright © 2003 Business Objects SA - All Rights Reserved

Slide 29 - - Copyright © 2003 Business Objects SA - All Rights Reserved

Business Objects 9 i OLAP Access • Business Objects 9 i OLAP access advantages • Resolve relational view challenges • Fully leverage 9 i OLAP server side calculations and create custom local calculation • Integrate both 9 i OLAP and 9 i relational data Slide 30 - - Copyright © 2003 Business Objects SA - All Rights Reserved

Slide 31 - - Copyright © 2003 Business Objects SA - All Rights Reserved

Works with all Business Objects clients Slide 32 - - Copyright © 2003 Business

Summary • Business Objects and Enterprise 6 • Enable end user autonomy with IT control • Business Objects and Oracle • Excellent integration • Business Objects and 9 i OLAP • Performance • Calculations • Integrate OLAP and relational Slide 33 - - Copyright © 2003 Business Objects SA - All Rights Reserved