Oracle Business Intelligence Maps Integration * In the

1
Oracle Business Intelligence Maps Integration
2
MapViewer (Leverage Oracle Maps Feature)

• Easy to use Javascript API
• No plug-ins
• Sample data with many demos.
• Demos include source code.

3
New Depth to Analysis Location Intelligence

• 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

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.
4
Uncover Patterns Hidden in TablesNew Spatial
Integration Goes Beyond the Interface
5
Oracle Business Intelligence Publisher 11g
???
6
Agenda
ltInsert Picture Heregt

• Introduction
• Layout Editor
• Data Model Editor
• Scheduler Enhancements
• More Features
• Q A

7
All your Reports and Documents

• Purchase Orders

• Labels / Bar Codes

• Collateral

• Government Forms

• eText

• Invoices

• Operational Reports

• Correspondence

• Financial Statements

• Checks

8
Oracle BI Publisher
Integration with over 30 Oracle Applications and
Products Over 35,000 customers Fully integrated
with Business Intelligence Enterprise Edition
9
Oracle BI Publisher 11g

• 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

10
Oracle BI Publisher 11g

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

11
Agenda
ltInsert Picture Heregt

• Introduction
• Layout Editor
• Data Model Editor
• Scheduler Enhancements
• More Features
• Q A

12
Layout EditorWYSIWIG Layout Designer
Ribbon Style Menu
Data Source brings all the fields defined in the
data model
13
Layout EditorWYSIWIG Layout Designer
Context Sensitive Ribbon Style Menu
14
Layout EditorHigh fidelity pixel perfect report
output
15
Layout EditorInteractive output
16
Agenda
ltInsert Picture Heregt

• Introduction
• Layout Editor
• Data Model Editor
• Scheduler Enhancements
• More Features
• Q A

17
Data Model Editor

• Combine data from different data sources
• Structure data to optimize document generation

18
Data Model Editor

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

19
Data Model Editor

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

20
Agenda
ltInsert Picture Heregt

• Introduction
• Layout Editor
• Data Model Editor
• Scheduler Enhancements
• More Features
• Q A

21
Scheduler Enhancements

• Recurrence patterns
• Hourly
• Annually
• Specific Dates
• Multiple outputs
• Job History Management
• Send from History
• Dedicated Schedule Delivery Servers

22
Scheduler Enhancements

• Recurrence patterns
• Hourly
• Annually
• Specific Dates
• Multiple outputs
• Job History Management
• Send from History
• Dedicated Schedule Delivery Servers

23
Scheduler Enhancements

• Recurrence patterns
• Hourly
• Annually
• Specific Dates
• Multiple outputs
• Job History Management
• Send from History
• Dedicated Schedule Delivery Servers

24
Scheduler Enhancements

• Recurrence patterns
• Hourly
• Annually
• Specific Dates
• Multiple outputs
• Job History Management
• Send from History
• Dedicated Schedule Delivery Servers

Track delivery status of multiple output Send
output after delivery
25
Scheduler Enhancements

• Recurrence patterns
• Hourly
• Annually
• Specific Dates
• Multiple outputs
• Job History Management
• Send from History
• Dedicated Schedule Delivery Servers

26
Agenda
ltInsert Picture Heregt

• Introduction
• Layout Editor
• Data Model Editor
• Scheduler Enhancements
• More Features
• Q A

27
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

28
BI Publisher InnovationSub Template

• Sub Template defines shared functions for RTF
  templates
• XSL or RTF
• Examples
• Rich text
• Custom formatting
• Custom Calculation

29
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

30
BI Publisher InnovationPDF Optimization

• Link to repeating static pages
• Reduce size of PDF output

31
BI Publisher InnovationHandle Ultra-large PDF
files

• Split into smaller size files
• Provide index.html to find needed documents

32
BI Publisher IntegrationTighter BIEE Suite Plus
Integration

• Integrated Home Page
• Shared Repository
• Integrated Oracle FMW Security

33
BI Publisher IntegrationEnhanced Infrastructure
Lower TCO
Fusion Middleware integration

• Oracle Fusion Middleware Security
• Performance Monitoring
• Logging and Error Registry
• Audit Trail
• Process Control

34
BI Publisher IntegrationJDeveloper ADF
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

35
Agenda
ltInsert Picture Heregt

• Introduction
• Layout Editor
• Data Model Editor
• More Features
• Q A

36
Q

A