Graphic section divider
Download
1 / 41

Graphic Section Divider - PowerPoint PPT Presentation


  • 259 Views
  • Uploaded on

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

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' Graphic Section Divider' - anise


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


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 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.

  • Introduction

  • Essbase Product Strategy

  • New Essbase Features

  • Upcoming and Future Features


Complete enterprise business intelligence
Complete Enterprise Business Intelligence 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.

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


Oracle Business Intelligence Foundation Suite 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.

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 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.

Oracle Essbase

OBIEE EPM 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 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.


Oracle essbase roadmap
Oracle Essbase Roadmap 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.

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 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.

    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

    @ 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.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 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.

    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 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.

    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 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.

    Results are in Seconds


    What s next in essbase
    What’s Next in Essbase? 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.


    Essbase consumers
    Essbase Consumers 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.

    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 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.

    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 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.

    • 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 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.

    • 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) 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.

    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 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. 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 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.– 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 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.– 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 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.

    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 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.

    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 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.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 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.

    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 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.

    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 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.

    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 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.


    Renegade members
    Renegade Members 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.

    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 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.


    Cube deployment services cds
    Cube Deployment Services (CDS) 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.

    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… 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.

    • 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 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.


    Putting bso to the unfair test1
    Putting BSO to the (Unfair) Test 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.

    • 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 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.

    • 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 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.

    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.


    ad