Graphic section divider
This presentation is the property of its rightful owner.
Sponsored Links
1 / 41

Graphic Section Divider PowerPoint PPT Presentation


  • 201 Views
  • Uploaded on
  • Presentation posted in: General

Graphic Section Divider. Oracle Essbase New Features and Roadmap Update. Gabby Rubin Senior Director, Product Management John Baker Director, Analytics.

Download Presentation

Graphic Section Divider

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Graphic section divider

Graphic Section Divider


Oracle essbase new features and roadmap update

Oracle Essbase New Features and Roadmap Update

Gabby Rubin

Senior Director, Product Management

John Baker

Director, Analytics


Graphic section divider

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.


Program agenda

Program Agenda

  • Introduction

  • Essbase Product Strategy

  • New Essbase Features

  • Upcoming and Future Features


Complete enterprise business intelligence

Complete Enterprise Business Intelligence

Oracle Business Intelligence Foundation Suite

Enterprise Business Intelligence

Centralize semantic layer and definitions of all metrics, calculations, and measures for data-driven visualizations

Increase operational effectiveness from reports to planning that eliminates cost redundancy

PAST

PRESENT

FUTURE

COMMON ENTERPRISE INFORMATION MODEL


Graphic section divider

Oracle Business Intelligence Foundation Suite

Single Enterprise-Scale Business Analytics Platform

  • Unique Features

    • Common Enterprise Information Model with physical, semantic and presentation layers

    • Market-leading OLAP server for forward-looking analysis

    • Single set of metrics across the enterprise

  • Benefits

    • Improve business performance by linking insight to action

    • Consistent enterprise metrics for improved productivity

    • Single analytic view across all data sources


Oracle business intelligence foundation suite

Oracle Business Intelligence Foundation Suite

Oracle Essbase

OBIEEEPM Microsoft Office

  • Essbase provides a platform to build analytic applications which allows users to model, analyze, and interpret complex business scenarios

  • Benefits

    • Enables ‘speed of thought’ modeling of alternative scenarios

    • Simplifies the forecasting and variance analysis processes

    • Secure, shared, single version of the truth

    • Centralized functions, calculations, aggregations

  • Unique Features

    • Ease of use for model creation and analysis

    • Users use familiar tools to analyze – mainly Excel

    • A centralized enterprise-scale solution

    • Financial & time intelligence

    • High performance for complex analysis

  • Oracle Essbase Server

  • Enterprise scale

  • Optimized multidimensional storage

  • Over 350 analytic functions

  • Financial, time and calendar intelligence

  • Multi user write-back

  • Trickle feed


New essbase features

New Essbase Features


Oracle essbase roadmap

Oracle Essbase Roadmap

Subject to Change

  • Calclanguage enhancements

    • Calc run-time parameters – sub-variable improvements

    • New calc functions

      • @ISMBRUDA, @MEMBERAT, @RANGEHASVAL, @RANGEFIRSTVAL, @RANGELASTVAL, @INTERSECT, @CREATEBLOCK

  • Performance

    • JAPI performance for outline editing

    • Dim Build performance improvements

      • ASO with multiple attributes

    • XREF performance enhancements (1/2)

  • BI Specific (BI Server, OBIEE, Infra)

    • BI – MDX performance improvements

    • BI PS – new Essbase related features

      • Parent last, null suppression control, enhanced member selection

    • FMW security, BI Shiphome delivery

  • Resolve naming restrictions

  • Security filter callback

  • Dimension member properties

  • APS/Essbase custom aggregates and lists

  • Calc language enhancements

    • Adding @XRANGE support for 30 functions

    • Parallel Fix

  • Performance

    • MDX performance

      • Sub Select

      • Aggregate function

    • JAPI performance for batch outline editing

    • XREF performance enhancements (2/2)

    • ASO in BSO Hybrid Mode (1/2)

  • BI Related

    • Cube Deployment Services v1

    • Null dimension members (via CDS)

    • Renegade members

    • MOLAP Aggregation

  • Cube Deployment Services v2

  • Enhanced Financial Logic

  • Aggregation Weight

  • Java Agent

  • Sandboxing

  • BSO Solve Order

  • Hot Backup

  • Active-Active

  • Essbase ADF controls

  • Calc language enhancements

    • New functions

    • For Loop

  • Performance

    • ASO in BSO Hybrid Mode (2/2)

    • Dim Build performance improvements (BSO)

  • Essbase 11.1.2.3/BI 11.1.1.7

    April-June 2013

    What’s Next

    0-12 month planning cycle

    Future DirectionsPost 12 month planning cycle

    For information purposes only, not a commitment to the development, release, and timing of any features or functionality.


    Increased integration with bi

    Increased Integration with BI

    BI 11.1.1.7 (Essbase 11.1.2.2.200)

    • Essbase as part of the BISHIPHOME

    • Essbase related features in Presentation Services

      • Null Suppression control

      • Parent-Last drill down

    • Support for FMW security

    • Improvements to MDX generation and performance


    New essbase calc functions

    @MEMBERAT ( mbrList, mbrIndex)

    Returns the specified member in a list of members based on an index

    @MEMBERAT(@CHILDREN(“Colas”), 1)

    @ISRANGENOTEMPTY (SKIPMISSING | SKIPZERO | SKIPBOTH, mbrlist)

    Returns TRUE is the specific member list contains at list one data item

    @ISRANGENOTEMPTY (SKIPMISSING, Sales->Cola)

    @RANGEFIRSTVAL (SKIPMISSING | SKIPZERO | SKIPBOTH | SKIPNONE, mbrlist)

    Returns the first data value in a range

    @RANGEFIRSTVAL (SKIPBOTH, @CHILDREN(“Qtr1”))

    @RANGELASTVAL (SKIPMISSING | SKIPZERO | SKIPBOTH | SKIPNONE, mbrlist)

    Returns the last data value in a range

    @RANGELASTVAL (SKIPMISSING, @CHILDREN(“Qtr4”))

    @ISMBRUDA (mbrName, UDAstr)

    Checks if a UDA is defined for a specific member (similar to @ISUDA which works on the current member)

    @ISUDA ( “New York”, “Major Market”)

    @INTERSECT ( list1, list2 )

    Returns the list of members that appear in both specified lists

    @INTERSECT (@CHILDREN(“Colas”),@ATTRIBUTE(can))

    @CREATEBLOCK ( mbrName)

    Creates a block with a sparse member name or a sparse member combination

    @CREATEBLOCK ( “100-10”->”New York”)

    New Essbase Calc Functions

    EPM 11.1.2.3 (Essbase 11.1.2.3)

    Have you tried any of the new functions?


    Run time substitution variables

    Run Time Substitution Variables

    EPM 11.1.2.3 (Essbase 11.1.2.3)

    • Run time sub-variables that can be initialized at the calc script level and changed at run time

      • Opens up Essbase for new analytics use cases

      • Allow concurrent users to perform custom advanced analytics using different parameters

      • EXECUTE CALCULATION Sample.Basic.Calc3 WITH RUNTIMESUBVARS ‘salesNum=100;Discount=50’;

      • SET RUNTIMESUBVARS{myMarket = “California”;myCity = “Sunnyvale”, “Santa Clara”, “San Jose”;salesNum = 100;startDate = @TODATE(“DD/MM/YY”,”10/11/12”);pointD = “Actual”->”Final”;};

    Do you have plans to use RTSV?


    Performance enhancements

    Performance Enhancements

    EPM 11.1.2.3 (Essbase 11.1.2.3)

    • XREF Performance Improvements

      • Up to 40X better than previous releases

      • Still slower compared to same cube access, but reasonably close

    • JAPI Outline Functions Enhancements

      • Improve the resource management of the JAPI outline functions

      • Allow for higher concurrency in applications that allow outline editing

    • ASO Dim Build Performance

      • Specifically with duplicate members


    Xref query test

    XREF Query Test

    Results are in Seconds


    What s next in essbase

    What’s Next in Essbase?


    Essbase consumers

    Essbase Consumers

    Planning

    • Standalone

    • BI

    • EPM

    • Exalytics

    • Essbase

    • Fusion

    BI Server

    HPCM

    • Standalone

      • Customers building customer EPM, LOB BI and analytical applications

    • EPM Portfolio

      • Hyperion Planning (and related apps) and HPCM are built on top of Essbase

    • BI and Exalytics

      • Essbase is part of BI Foundation Suite delivering capabilities around financial and time based analysis, projections and simulation

      • Specific performance features targeted at Exalytics

    • Fusion

      • Currently 3 Fusion apps are using Essbase (GL balances, CRM territory management, Projects performance)

      • Essbase is completely embedded in the apps

    BI Apps

    LOB BI

    Simulations

    GL

    Custom

    EPM

    Projects

    CRM


    Oracle essbase roadmap1

    Oracle Essbase Roadmap

    Subject to Change

    • Calclanguage enhancements

      • Calc run-time parameters – sub-variable improvements

      • New calc functions

        • @ISMBRUDA, @MEMBERAT, @RANGEHASVAL, @RANGEFIRSTVAL, @RANGELASTVAL, @INTERSECT, @CREATEBLOCK

    • Performance

      • JAPI performance for outline editing

      • Dim Build performance improvements

        • ASO with multiple attributes

      • XREF performance enhancements (1/2)

    • BI Specific (BI Server, OBIEE, Infra)

      • BI – MDX performance improvements

      • BI PS – new Essbase related features

        • Parent last, null suppression control, enhanced member selection

      • FMW security, BI Shiphome delivery

    • Resolve naming restrictions

    • Security filter callback

    • Dimension member properties

    • APS/Essbase custom aggregates and lists

    • Calc language enhancements

      • Adding @XRANGE support for 30 functions

      • Parallel Fix

    • Performance

      • MDX performance

        • Sub Select

        • Aggregate function

      • JAPI performance for batch outline editing

      • XREF performance enhancements (2/2)

      • ASO in BSO Hybrid Mode (1/2)

    • BI Related

      • Cube Deployment Services v1

      • Null dimension members (via CDS)

      • Renegade members

      • MOLAP Aggregation

    • Cube Deployment Services v2

  • Enhanced Financial Logic

  • Aggregation Weight

  • Java Agent

  • Sandboxing

  • BSO Solve Order

  • Hot Backup

  • Active-Active

  • Essbase ADF controls

  • Calc language enhancements

    • New functions

    • For Loop

  • Performance

    • ASO in BSO Hybrid Mode (2/2)

    • Dim Build performance improvements (BSO)

  • Essbase 11.1.2.3/BI 11.1.1.7

    April-June 2013

    What’s Next

    0-12 month planning cycle

    Future DirectionsPost 12 month planning cycle

    For information purposes only, not a commitment to the development, release, and timing of any features or functionality.


    Prefix

    Prefix

    • Presented features represents our current 12 months plan

    • Development plans are subject to change, do not make buying decisions based on future features!

    • When released, some features might be restricted to BI, EPM or Exalytics


    Make essbase better at what essbase is best

    Make Essbase Better at What Essbase is Best

    • Improved quality and stability

    • Enhance the Calc Language

    • Performance, Performance, Performance

      • Queries, calc, APIs…

      • Generic and Exalytics

      • ASO, BSO and more…

    • Continue to improve BI Integration

    • Simplified sophistication


    Fixparallel block 1 4

    FIXPARALLEL Block (1/4)

    Subject to Change

    • Eliminate restrictions of CALCPARALLEL

      • Execute any FIX commands in parallel

    • Give power of parallelism to the users

      • Ability to control the task dimensions used for division of work, not dependent on outline order

      • Extend ESSBASE support for parallelism:

        • XREF, XWRITE

        • DATACOPY, DATAEXPORT


    Fixparallel block 2 4

    FIXPARALLEL Block (2/4)

    Subject to Change

    • Enable parallel calculation on a block of command using a specific number of threads

      • FIXPARALLEL (numThreads, mbrList)[ SET TASKSIZE = UNIQUE| ANALYZE | analyze-output ; ]COMMANDS ;[ POSTFIXPARALLEL ( [ varName = ACCUMULATEVAR ( staticParVarName ); ]* ); ]ENDFIXPARALLEL

    • New types of variables

      • Initialized for each thread THREADPARVAR varName [= value];

      • Initialized for each task within a threadTASKPARVAR varName [= value];

    • Supports FIX within FIXPARALLEL and FIXPARALLEL within FIX


    Fixparallel examples 3 4

    FIXPARALLEL – Examples (3/4)

    Subject to Change

    • Sample.Basic with added dimensions

    • Tested on Exalytics with RAM Drive

    • Use DATAEXPORT to write a section of database to files

      • CALCPARALLEL does not support DATAEXPORT

    BEFORE

    FIX ( @CHILDREN(“East”, …) )

    DATAEXPORT “File” “ ” “dexp.txt” “#Mi”;

    ENDFIX

    AFTER

    FIXPARALLEL (8, @CHILDREN(“East”, …) )

    DATAEXPORT “File” “ ” “dexp.txt” “#Mi”;

    ENDFIXPARALLEL

    • Important Disclaimer

    • Based on a release/platform still under development


    Fixparallel examples 4 4

    FIXPARALLEL – Examples (4/4)

    Subject to Change

    • Sample.Basic with added dimensions.

    • Tested on EXALYTICS with RAMDISK.

    • Use DATACOPY to copy 10,000 blocks with block size of 16K

    • CALCPARALLEL does not support DATACOPY

    BEFORE

    FIX ( @RELATIVE(“Version”, 0))

    DATACOPY “100-10” TO “300-10”;

    ENDFIX

    AFTER

    FIXPARALLEL (4, @RELATIVE(“Version”, 0))

    DATACOPY “100-10” TO “300-10”;

    ENDFIXPARALLEL

    • Important Disclaimer

    • Based on a release/platform still under development


    Additional calc language enhancements

    Additional CALC Language Enhancements

    Subject to Change

    • @XRANGE Support in Functions

      • Currently @XRANGE is supported by about 14 functions

        • @AVGRANGE(Sales, @XRANGE(“2012”->Jul,”2012”->Jun))

      • @XRANGE will support 30 additional functions that currently supports range lists

        • E.g. @ALLOCATE, @COUNT, @PTD, @RANK, @IRR, @VARIANCE

    • String manipulation functions

    • Support for FOR LOOP


    Essbase exalytics bso performance project

    Essbase/Exalytics BSO Performance Project

    B-tree Extended Memory Scalability

    Queries per Minute

    Number of vUsers

    • Important Disclaimer

    • Based on a release/platform still under development


    Provider services smartview recorder

    Provider Services SmartView Recorder

    Subject to Change

    • OTN based utility – not a product feature!

    • Useful for workload and data quality testing with SV and Essbase

      • Post upgrade data quality

      • Concurrent workload tests

    • Record user activity in Smartview (capture APS requests)

    • Replay the activity

      • Check for differences in returned data

      • Can simulate concurrent users

      • TBD: Performance measurements


    Bi molap based aggregation

    BI MOLAP Based Aggregation

    Subject to Change

    • Using Essbase to accelerate queries in OBIEE has been a long standing goal

      • BI will greatly benefit from Essbase as a query accelerator

    • To provide a viable solution we need to:

      • Ensure performance and scale

      • Resolve modeling issues

      • Resolve data issues

      • Simplify integration


    Mdx improvements

    MDX Improvements

    Subject to Change

    • MDX Optimization for Attributes

    • Optimized Aggregate Command

      • Significant performance improvements for totals at multi-level hierarchies

      • Improvement is based on the query and dimension depth

    • MDX Sub Select

      • Significant performance improvement for queries against large databases

      • The bigger the model, the (relatively) better it gets


    Resolve member name restrictions

    Resolve Member Name Restrictions

    Subject to Change

    • Remove many of the naming restrictions for Essbase

      • Object name length

      • Reserved words

      • Restrictions on characters

    • Initial support will be restricted to JAPI and data loaded from SQL sources

    • Uniqueness will be address in later releases


    Data issues between rdbms and essbase

    Data Issues Between RDBMS and Essbase


    Renegade members

    Renegade Members

    Subject to Change

    • A selected member which will collect the data from rejected records of the dimension

      • Every dimension can have one (with one exception)

    • Renegade records are logged in a similar way to rejected records, but remember to clear the renegade member before reloading them

    • Best practices

      • It should be in Generation 2 of the dimension, but there is no validation for it

      • Cannot have one for the Measure dimension


    Renegade members1

    Renegade Members


    Cube deployment services cds

    Cube Deployment Services (CDS)

    Subject to Change

    • XML based database creation

      • Complete cube definition is constructed in an XML file

    • Ease of integration with other tools and platforms

    • Cloud ready (reduce API chatter)

      • Competed XMLs are processed by Essbase CDS which creates the Essbase database and load rules

    • Web Services based API

    • Initial release will be limited and will be used only for BI MOLAP aggregation


    The essbase engine dilemma

    The Essbase Engine Dilemma…

    • Should I use BSO or ASO? Sparse vs. Dense?

      • Custom consolidation = BSO

      • Write back = BSO

      • Dynamic aggregation = ASO


    Putting bso to the unfair test

    Putting BSO to the (Unfair) Test


    Putting bso to the unfair test1

    Putting BSO to the (Unfair) Test

    • 14 Dimension

    • Data loaded only at Level 0 (everything will need to be dynamic)

    • 10 very nasty queries with combinations of totals at various levels


    Introducing bso aso hybrid mode

    Introducing: BSO/ASO Hybrid Mode

    • Standard BSO database with BSO capabilities coupled with ASO dynamic performance

    • Use ASO query processor for BSO dynamic aggregation

    • It is BSO - supports CALC scripts, write-back, CALC formulas, etc.

  • Specific optimizations for specific use cases

    • Might even be faster than ASO in some scenarios


  • Oracle essbase roadmap2

    Oracle Essbase Roadmap

    Subject to Change

    • Calclanguage enhancements

      • Calc run-time parameters – sub-variable improvements

      • New calc functions

        • @ISMBRUDA, @MEMBERAT, @RANGEHASVAL, @RANGEFIRSTVAL, @RANGELASTVAL, @INTERSECT, @CREATEBLOCK

    • Performance

      • JAPI performance for outline editing

      • Dim Build performance improvements

        • ASO with multiple attributes

      • XREF performance enhancements (1/2)

    • BI Specific (BI Server, OBIEE, Infra)

      • BI – MDX performance improvements

      • BI PS – new Essbase related features

        • Parent last, null suppression control, enhanced member selection

      • FMW security, BI Shiphome delivery

    • Resolve naming restrictions

    • Security filter callback

    • Dimension member properties

    • APS/Essbase custom aggregates and lists

    • Calc language enhancements

      • Adding @XRANGE support for 30 functions

      • Parallel Fix

    • Performance

      • MDX performance

        • Sub Select

        • Aggregate function

      • JAPI performance for batch outline editing

      • XREF performance enhancements (2/2)

      • ASO in BSO Hybrid Mode (1/2)

    • BI Related

      • Cube Deployment Services v1

      • Null dimension members (via CDS)

      • Renegade members

      • BI Java Agent

    • Cube Deployment Services v2

  • Enhanced Financial Logic

  • Aggregation Weight

  • Java Agent

  • Sandboxing

  • BSO Solve Order

  • Hot Backup

  • Active-Active

  • Essbase ADF controls

  • Calc language enhancements

    • New functions

    • For Loop

  • Performance

    • ASO in BSO Hybrid Mode (2/2)

    • Dim Build performance improvements (BSO)

  • Essbase 11.1.2.3/BI 11.1.1.7

    April-June 2013

    What’s Next

    0-12 month planning cycle

    Future DirectionsPost 12 month planning cycle

    For information purposes only, not a commitment to the development, release, and timing of any features or functionality.


  • Login