graphic section divider
Download
Skip this Video
Download Presentation
Graphic Section Divider

Loading in 2 Seconds...

play fullscreen
1 / 41

Graphic Section Divider - PowerPoint PPT Presentation


  • 267 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
oracle essbase new features and roadmap update
Oracle Essbase New Features and Roadmap Update

Gabby Rubin

Senior Director, Product Management

John Baker

Director, Analytics

slide4

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

slide7

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

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

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

ad