Oracle Business Intelligence Maps Integration

MapViewer (Leverage Oracle Maps Feature)

• Easy to use Javascript API

• No plug-ins• Sample data

with many demos.

• Demos include source code.

In effect, Oracle is "flipping the switch" and turning spatial into a product feature when such a capability is needed. It will be daunting to compete against this company.

Microsoft, beware… we haven't heard much about geospatial and SQL Server integration lately… you are in danger of becoming a non-player. And IBM continues to play with ESRI only, and resists striking out on its own in what could be a missed opportunity.

• Most BI data already contains geographic dimension of analysis

• Deliver deeper analytical insights through Spatial visualisation and data

• Increase the ROI of BI & GIS systems

New Depth to Analysis: Location Intelligence

Uncover Patterns Hidden in TablesNew Spatial Integration Goes Beyond the Interface

Oracle Business Intelligence Publisher 11g

???

<Insert Picture Here>

Agenda

• Introduction

• Layout Editor

• Data Model Editor

• Scheduler Enhancements

• More Features

• Q & A

Government Forms

Invoices

Operational Reports

Correspondence

Financial Statements

Checks

Purchase Orders

Labels / Bar Codes

Collateral

eText

All your Reports and Documents

Oracle BI Publisher

Integration with over 30 Oracle Applications and Products

Over 35,000 customers

Fully integrated with Business Intelligence Enterprise Edition

• BI Publisher Layout Editor– Web-based WYSIWYG

layout design editor– Interactive HTML output

format• Data Model Editor

– Combine data from multiple data sources

– Filter & structure data– New data sources: Excel,

LDAP, VO• Scheduling & Bursting

Enhancements– Recurrence Patterns– Multiple named outputs to

multiple destinations

• Tighter integration with OBIEE– Web catalog integration– Home page integration– Security integration

• Sub Templates & Style Templates

• PDF Optimization• JDeveloper & ADF

integration• Redesigned Web interface

Oracle BI Publisher 11g

Oracle BI Publisher 11g

• Focus on 3 features• Layout Editor• Data Model Editor• Scheduler

<Insert Picture Here>

Agenda

• Introduction

• Layout Editor

• Data Model Editor

• Scheduler Enhancements

• More Features

• Q & A

Layout EditorWYSIWIG Layout Designer

Data Source bringsall the fields definedin the data model

Ribbon Style Menu

Properties forAdvanced user

Context SensitiveRibbon Style Menu

Layout EditorWYSIWIG Layout Designer

Layout EditorHigh fidelity pixel perfect report output

Layout EditorInteractive output

<Insert Picture Here>

Agenda

• Introduction

• Layout Editor

• Data Model Editor

• Scheduler Enhancements

• More Features

• Q & A

Data Model Editor

• Combine data from different data sources

• Structure data to optimize document generation

Data Model Editor

• Support for new data sources– Excel– LDAP– ADF View Object

Data Model Editor

• Create business friendly views by defining aliases for XML element names

<Insert Picture Here>

Agenda

• Introduction

• Layout Editor

• Data Model Editor

• Scheduler Enhancements

• More Features

• Q & A

Scheduler Enhancements• Recurrence

patterns– Hourly

– Annually

– Specific Dates

• Multiple outputs• Job & History

Management• Send from History• Dedicated Schedule

& Delivery Servers

• Recurrence patterns– Hourly

– Annually

– Specific Dates

• Multiple outputs• Job & History

Management• Send from History• Dedicated Schedule

& Delivery Servers

Scheduler Enhancements

• Recurrence patterns

• Hourly

• Annually

• Specific Dates

• Multiple outputs

• Job & History Management

• Send from History

• Dedicated Schedule & Delivery Servers

Scheduler Enhancements

Track delivery status of multiple outputSend output after delivery

• Recurrence patterns

• Hourly

• Annually

• Specific Dates

• Multiple outputs

• Job & History Management

• Send from History

• Dedicated Schedule & Delivery Servers

Scheduler Enhancements

• Recurrence patterns

• Hourly

• Annually

• Specific Dates

• Multiple outputs

• Job & History Management

• Send from History

• Dedicated Schedule & Delivery Servers

Scheduler Enhancements

<Insert Picture Here>

Agenda

• Introduction

• Layout Editor

• Data Model Editor

• Scheduler Enhancements

• More Features

• Q & A

BI Publisher InnovationStyle Template

• Style Template defines styles of layout objects for RTF template

• Apply Style Template styles to RTF template at runtime

• Supported styles– Table– Paragraph– Header/Footer

BI Publisher InnovationSub Template

• Sub Template defines shared functions for RTF templates

• XSL or RTF

• Examples:

– Rich text

– Custom formatting

– Custom Calculation

BI Publisher InnovationTemplate Builder & RTF Template Enhancements

• Ribbon Toolbar• Gauges• Dual Y Charts• Running Totals• Form fields up to 40k• Group Left Enhancements• Style Templates• Sample Data• Business View support• Non Admin User install

BI Publisher InnovationPDF Optimization

• Link to repeating static pages

• Reduce size of PDF output

BI Publisher InnovationHandle Ultra-large PDF files

• Split into smaller size files

• Provide index.html to find needed documents

BI Publisher IntegrationTighter BIEE Suite Plus Integration• Integrated

Home Page• Shared

Repository• Integrated

Oracle FMW Security

BI Publisher IntegrationEnhanced Infrastructure – Lower TCO

• Oracle Fusion Middleware Security

• Performance Monitoring

• Logging and Error Registry

• Audit Trail• Process Control

Fusion Middleware integration

• BI Publisher ADF components in JDeveloper

• Use JDeveloper to build ADF applications with BI Publisher reports

• Use ADF View Objects as report data source

BI Publisher IntegrationJDeveloper & ADF Integration

<Insert Picture Here>

Agenda

• Introduction

• Layout Editor

• Data Model Editor

• More Features

• Q & A

AQ&