CON9326_Berkowitz-CON9326 - BI_FoundationSuite_Update

hurriedtinkleΤεχνίτη Νοημοσύνη και Ρομποτική

15 Νοε 2013 (πριν από 3 χρόνια και 6 μήνες)

195 εμφανίσεις

Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

1

Oracle Business Intelligence
Foundation Suite: Overview and
Roadmap

Jack Berkowitz

Vice President, Product Management




Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

3


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 IN MAKING PURCHASING DECISIONS. THE
DEVELOPMENT, RELEASE, AND TIMING OF ANY FEATURES OR
FUNCTIONALITY DESCRIBED FOR ORACLE'S PRODUCTS
REMAINS AT THE SOLE DISCRETION OF ORACLE.

Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

4

Program Agenda


OBI Foundation Suite 11.1.1.7 release


Key Features


Oracle Smart View


Hadoop

Integration


Advanced Analytics & Spatial Integration


From the Labs…


Roadmap

Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

5

Oracle Complete Business Analytics Solution

Integrated

Analytic
Applications




Any Data,

Any Source




Full Range of
Analytics




On Premise,

On Cloud,

On Mobile




Oracle
BI
Foundation Suite
11.1.1.7

Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

7


Continual touch points against
the shared/central semantic
experience


Exploiting device capabilities
and natural interaction styles


Provide information and access
appropriate to the decision
making needs

Coherent & Pervasive Use

Overall BI User Experience

Oracle BI Foundation

Tablet

Laptop


Dashboards

Ad hoc

Scorecards

Reporting

Search

Discovery

Alerting

Cloud

Office

Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

8

OBIEE 11.1.1.7

New and Improved Visualizations

100% Stacked Bar

Compare distributions within categories and also
display the differences between categories

View Suggestions

An algorithm will determine which visualization type
would be best suited for the display of current data

Freeze Headers

Anchor the header for large tables or pivot views

Trellis Chart Grid

Data
-
dense view type displays large amounts of
data for comparative analysis.

Performance Tiles

Immediately reveals summary metrics to the end
user that will likely also be presented in larger, more
detailed Dashboard views.

Waterfall

Determine how an initial value is affected by a
series of intermediate positive or negative values

Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

9

OBIEE 11.1.1.7

User Interaction Improvements

Better Search

Facet
-
based UI for full
-
text search for Oracle BI,
leveraging Endeca MDEX technology

Save As
Analysis on
Dashboard

New Save
-
as option when
editing Analysis from
dashboard replace the
updated analysis within the
dashboard

Breadcrumbs

Contextual awareness and
Breadcrumbs for easy navigation

Trellis Actions

Context per bar in Simple Treliis

Action for entire cell in Advanced Trellis

Navigation / Actions
from Totals

Pass context to any Action Framework
process

Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

10

OBIEE 11.1.1.7

Production Reporting Improvements

Export Dashboard to BI Publisher


Export Dashboard to BI Publisher Layout, with automatic
Data Model & Report creation, and export of supported
Views and styles


Export Dashboard to Office formats


Template Based
Printing of Dashboards


Pixel
-
perfect printing of Dashboards


Associate multiple templates to
Dashboard


Dashboard state supported


BI Publisher Direct Access
to Semantic Layer


Use one or more subject areas to create
reports in Publisher


No need to create a data model
beforehand


Execute logical SQL directly against BI
Server using JBIPS

Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

11

OBIEE 11.1.1.7

Oracle BI Mobile Improvements

Advanced Visualizations

Performance Tile, Waterfall, Trellis views enabled
for mobile interactions; Swipe gesture to navigate
data in tables

BI Mobile App Designer

Offline support and fully interactive views on BI
Mobile client

Maximize Views

Double
-
tap to maximize/restore view; utilizes full
consumable real
-
estate on the device

BI Mobile Security Toolkit

Available via OTN download. Supports the
internal delivery of a packaged/certified BI
Mobile application. Specialized licensing
restricts customizations to security
modifications

Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

12

Oracle Smart View

Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

13

OBIEE 11.1.1.7

Office Integration Improvements

BI Presentation Catalog in
Smart View


Smart View 11.1.2.2 replaces the existing
Oracle BI Add
-
in as the primary Office
application


Full support for BI dashboard page and
report prompts


Enhanced security including single sign
-
on

Export Dashboards &

Dashboard Content


Export Report in Native Excel &
PowerPoint formats (2003, 2007+)


Export Dashboard or Dashboard page;
Dashboard pages appear as separate
Excel worksheets

BI View Creation in

Smart View


Answers View creation from Excel


Save in Excel or as an Answers View


Publish and save in the OBIEE Web Catalog


OBI Data is accessible to other Smart View
providers (e.g. Planning, HFM, DM)

Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

14

Self
-
Service Access to BI Content

Discovery and Import of Pre
-
built
Views and Dashboards


Focus on native Office functionality


Supporting Charts, Excel Pivot,
Templates and Word


Full support for BI page and report
prompts


Self
-
service modification of BI
Views


Modifying the chart type, chart layout and
the design properties associated with the
visualizations.


End users can control the formatting and
representation based on business need
or personal preference without the
involvement of IT or BI report designers.



Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

15

Integration with Highly Formatted OBIEE Views

Enable easy content re
-
use


Leverage the customizations and view
standards used within an OBIEE
environment.


All view designed modifications such as
conditional formatting, background colors
or data configuration is automatically
translated to the Office environment.


Policy based import and lineage
tracking


Provides the ability set preferences on
how content is refreshed and updated.


Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

16

Self
-
Service Report Creation

Enables users to create new Views from
all of the Microsoft Office components
.


This self
-
service reporting capability permits users
to connect to the OBIEE semantic layer, select
dimensions and measures, apply filters, page
prompts, totals and either OBIEE or Office based
analytic types.

Support Native Office features


Save content in Office in native format including
Excel Pivot Tables


No loss of interoperability with OBIEE

Publish to the BI Catalog


The resulting analysis can also be saved back to
the OBIEE Web Catalog and shared through the
standard dashboard or distributed reporting
mechanisms.


Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

17

Enabling Power Point Functionality

Native Microsoft Power Point
features


Smart View enables the full support
and maintenance of BI Analyses in
Power Point.


Features unique to Power Point include
the ability to apply native templates
and leverage core design features.

Maintenance of Presentations


Allow end users to build and maintain a
consistent presentation adhering to
appropriate business/corporate
standards.


Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

18

Data Federation Across Sources

Support multiple data source
providers


OBI Data is accessible to other Smart
View providers (e.g. Planning, HFM,
DM)


Allows Office to become a center point
for mixed data

Connectivity


Single point of connections allowing for
mixed data sources


Enhanced security including single sign
-
on



Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

19

BI Server & Hadoop Integration

Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

20

BI Server Roadmap Highlights


New data source integrations continue to be supported by the BI Server in the most
recent releases


…and new data sources integrations are planned for upcoming releases


Hadoop

data sources can be directly accessed by the BI Server through the Hive
interface


BI Server dynamically generates
HiveQL

to access
Hadoop


Hadoop

data can be federated with other supported sources


Exalytics

and
TimesTen

aggregates can be leveraged for fast and predictable performance against Big
Data sources


Bi
-
direction Integration with
Endeca

Information Discovery


Endeca

Server can “ingest” data through the BI Server for Discovery applications


Endeca

sources can be queried directly through OBIEE for custom BI applications




Hadoop and Endeca Integration


Available Now

Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

21

BI Server Roadmap Highlights

Data Source Integration
-

Planned



Greater diversity of relevant data sources required for analytic
applications,
e.g

Big Data, Cloud, Social


Cloud requires re
-
thinking of where data is accessed from, i.e. on
-
premise or through the public Internet


Planned data source abstraction project will provide an Open API to
extend the BI Server source support


Plug in any data source that can be accessed via Java to the BI Server


Will not require code changes to the BI Server to add a data source


API will support both internal and third
-
party development


Key benefit
is the ability to
rapidly respond to new data source requirements



Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

22

BI Server Roadmap Highlights

Thin Client Modeling Tools
-

Planned


Requirement for a tool strategy that supports
both Cloud and On
-
Premise metadata
development


Thin
-
Client Modeler to be delivered with BI
Cloud Service v1


Web
-
based tool designed for the business user


Masks the complexity in creating a model with
Admin Tool


Thin
-
Client Modeling tool planned for Fusion
SaaS


Future goal is to deliver thin
-
client tool with
comparable functionality to replace the legacy
Admin Tool


Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

23

BI Server Roadmap Highlights

Metadata Architecture
-

Planned

Thin Client UI

Admin Tool

RPD

Metadata Services

BI Admin Tool


BI Metadata Modeler



Requirement for a metadata architecture
that supports iterative multi
-
user
development with discrete ownership of
objects, easy upgrades/patching, and rapid
deployment


Roadmap Features


Metadata stored in XML repository


Metadata packaged as archives


Export / Import / Migration / Deployment


Metadata objects shared across projects


Ownership assignment to discrete metadata
objects and projects



XML DB

Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

24

Advanced Analytics & Spatial

Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

25

Advanced Analytics Benefits all BI Processes


Every functional BI process largely benefits from leveraging Advanced Analytics


Every BI Application gets a value lift of embedding AA techniques

Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

26

OBIEE SampleApp Image

Immediate Ramp
-
up & Proficiency

Comprehensive library of functional examples of
BIEE in action

Numerous configuration best practices to rapidly
master BIEE investment

Extensive cross
-
stack Advanced Analytics examples :
optimize BIEE with other Oracle assets

Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

27

Unique Features


Every OBIEE feature demonstrated in actual built
examples,


Hundreds of configuration &
customization
best
practices,


Rich Advanced Analytics integration examples,

Benefits


Rapidly learn and deploy powerful OBIEE
capabilities,


Immediately adopt design and configuration best
practices



Oracle BIEE SampleApp

Quickly Ramp
-
up the OBIEE Learning Curve

Turnkey, free companion image available at :

http://www.oracle.com/technetwork/middleware/bi
-
foundation/obiee
-
samples
-
167534.html



Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

28

Database Analytics in OBIEE SampleApp (V309)

ODM

& PREDICTIVE

ORE

DB

CLAUSES &
FUNCTIONS

SPATIAL

TEXT

TEMPORAL AND
TIME

ODM model results
Visualization

R Visuals Blob
Integration in
dashboard

Data Binning and
Distribution

Point to point /
Address to Point
Distance Analytics

Mining &
Tokenization (Word

Distribution)

Temporal Query
(SCD)

Hierarchical view of
Classification Tree

R content End
-
User Interaction

Simple Regression
Functions

Point to polygon
Distance Analytics

Blending

Tokens
with Bus. Insights

Temporal Query at
Session Level

Explain clause :
Variables Significance

R Script Edit
from Dashboard

Pattern Detection



Mapviewer

Feature
layers (
Heatmaps
)

Advanced Text
Filtering

Dynamic
Timezone

Conversion

Dynamic Individual

What if Scoring

R Sourcing from
BI CEIM


Script

Descriptive Stats

Network Data Model

: Static Results

Text Classification

Dynamic DST
Conversion

Dynamic
Predictive

Queries :
Anomaly
Detection, Classification,
Regression

R calculation

embedded in
RPD

Models :
end
-
user interact

Frequent
Itemset

(Market Basket)

Network Data Model

: Dynamic

Refresh

Text Aggregation

Timespan

Calculations

Model Score Dynamic
Aggregation

BIP Sourcing
from R

Model Clause Inter
-
active Projection

Floor Plan
Background

Model Scores
conditional highlighting

Sourcing from Web
Services

Custom Geographies

Aggregation

Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

29

Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

30

From the Labs…

Ask

OBIEE

VOICE

SEARCH

EXALYTICS

Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

31


Familiar metaphor to access your BI content &
data


Installed by default with OBIEE


Interprets Semantic layer, Data & Catalog artifacts


Reports, KPIs, Dashboards & BI Mobile Apps



On
-
the
-
fly queries


Get answers to questions without authoring


Auto
-
suggest and generate visualizations ‘On
-
The
-
Fly’ to

guide users


Entry point into Answers, VA, Dashboard and authoring tools



Instrumented to capture statistics that will

drive prescriptive and proactive BI capabilities


Who is querying for What, When & Where


Statistics will improve suggestions over time

Oracle BI Ask

What is it ?

Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

32

Roadmap

Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

33

Oracle BI Foundation

Current Releases and Roadmap

Presentation Improvements


High Density Visualizations (
Treemap
, Heat
Matrix, KPI Wheel)


Usability Improvements for Answers &
Dashboards (quick calculations, subject area
joins, better right
-
click organization).


Improved export fidelity and speed


Smoother ORE & Advanced Analytics
integration


Exalytics Software Updates


Exalytics with Consolidation


Acceleration Improvements


Cloud


Multi
-
tenant Reporting Cloud Service


OBIEE uptake by
Taleo

and
Eloqua





What’s Next

0
-
12 month planning cycle

Exalytics v1 (March 2012)


Superfast in
-
memory Analytics machine


Summary advisor for automatic aggregations


TimesTen

for Aggregate Persistence


Speed of Thought Visualizations / Reporting


Memory optimized Essbase for M
-
OLAP


OBI 11.1.1.7 (April 2013)


New and Improved Visualizations


Mobile


authoring and consumption


Office Integration with SmartView


Printing & Reporting Improvements


Support for Big Data and streaming Data


More Complete
Essbase

Integration


Mobile App Designer


Essbase 11.1.2.2 (April 2012)


Essbase: Exalytics Support




What’s Available

Delivered in the last 12 months

Interactive Experiences


Visual Analysis (vs. SQL
-
like Authoring)


Eliminates silos between authoring (answers)
vs. consumption (dashboards)


Simple what
-
if
-
analysis in context


Intelligent Visualization defaulting


Cross
-
Platform Mobile BI


For both tablet and smart phone form factors


Blends authoring and consumption with the
ability to preserve prior content investments


Exalytics in front of Oracle DB In
-
Memory


In
-
memory performance against any source,
connection (w/ proprietary data structures)


Data mash
-
ups by building user specific
extensions to in
-
memory navigation spaces


This enables user
-
private data / sand
-
boxes


Extend semantic layer to support flexible
schemas; leverages MDEX underneath



Future Directions

Post 12 month planning cycle

Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

34



Oracle BI Server

BI Server Roadmap Summary



Hive integration for Apache
Hadoop

data
sources


Essbase

as a target for aggregates


DSN
-
less Connection String


Null
-
Unsuppress


Multi
-
Source Session Variables


Command Line Utility to change Repository
password


Additional database support for Cardinality
Estimates in Oracle BI Summary Advisor


Oracle BI Summary Advisor Measure Subset
Recommendations


Model Check Manager enhancements


NUMERIC Data Type Support for Oracle
Database and
TimesTen


Continuous Event Processing (CEP)
Gateway


Nested folder enhancements


Dynamic Presentation object visibility




V1 Thin Client Modeling Tools for
BIaaS
,
SaaS


Metadata API for fine grain changes


Versioned Metadata Gateway


Harden on
-
line changes


Multi
-
tenancy enhancements for BI Cloud
Service V1


Support for
Endeca

Server as a data source


Support Impala for access to
Hadoop


Support for Hyperion Planning as a data
source


JDBC connectivity to data sources


Support for Web Services data sources


Enhanced query generation for MOLAP
aggregates (
Exalytics
)


Enhancements to Aggregate Persistence
and Summary Advisor (
Exalytics
)


Integration with RTD and ORE Models



Thin Client Modeling tool for Cloud and On
-
Premise


XML metadata schema stored in relational


Metadata REST API


Multi
-
tenancy enhancements for Cloud


Server enhancements for Sandboxing



Data Mash
-
ups


Third Party Cloud Data Source Integration


Enhanced integration with Big Data sources


Support for
NoSQL

Databases


Further integration with Advanced Analytic
models


Further integration with CEP


Peoplesoft

OTBI


What’s Next

0
-
12 month planning cycle

Future Directions

12 month+ planning cycle

What’s Available

Delivered in the last 12 months

Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

35

Graphic Section Divider

Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

36