1 / 41

Graphic Section Divider

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

anise
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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Graphic Section Divider

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

  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.

  4. Program Agenda • Introduction • Essbase Product Strategy • New Essbase Features • Upcoming and Future Features

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

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

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

  8. New Essbase Features

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

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

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

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

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

  14. XREF Query Test Results are in Seconds

  15. What’s Next in Essbase?

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  30. Data Issues Between RDBMS and Essbase

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

  32. Renegade Members

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

  34. The Essbase Engine Dilemma… • Should I use BSO or ASO? Sparse vs. Dense? • Custom consolidation = BSO • Write back = BSO • Dynamic aggregation = ASO • …

  35. Putting BSO to the (Unfair) Test

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

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

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

More Related