get Oracle SmartView plugin

FixParralel vs CalcParallel

 

Oracle продолжает пиарить использование конструкции FixParralel, но что нужно знать

  1. CalcParallel работает быстрее, чем FiXParallel
  2. Но у CalcParallel есть ограничения.
  3. Для этих случаев используем FiXParallel.

 

Прощай FDM !

Еще пара тезисов с OOW14
1) В версии 11.1.2.3 появился мигратор с FDM на FDMEE (Existing  FDM customers may upgrade to FDMEE –FDM and FDMEE may be run in parallel )
2) Начиная с версии 11.1.2.4 FDM будет не доступен (Legacy FDM not available starting with release 11.1.2.4)

EPM News News News (Oracle OpenWorld, day 3)

ORACLE ESSBASE NEW FEATURES AND ROADMAP UPDATE

  • Reduce BSO fragmentation
    • This is Exalytics only
      • In-place block write
      • Slows fragmentation
    • Exalytics first optimization
      • It’s easier for Oracle to do this because it’s one platform as opposed to the many commodity hardware OSe
  • @RELXRANGE
    • Bugger, I missed it.  🙂
  • FOR LOOP
    • Two new variable types:  MEMBER and NUMBER
    • Syntax
    • FOR (mbr, mbrList)  Statement  ;  ENDFOR
    • No more block creation – this is outline driven, not block driven
  • Renegade
    • Selected member that will provide a home for orphaned members
      • No more dataload.err
  • Batch outline editing
    • New API to allow mass operations on Essbase Outline
      • Death to Load Rules!
      • Huge performance
  • Improved resource management and CPU utilization
    • Thread management and thread based memory allocation and management
    • Fundamental improvement to Essbase infrastructure
  • Essbase R
    • Library to read and write Essbase database from R
      • Connect
      • mdx2Array
      • writeBack
    • Future direction
      • Allow Essbase users to trigger R from Essbase
      • Embedded R in calc scripts
      • Generic capability to allow the extendibility of Essbase with 3rd party scripting languages
  • EAL financial intelligence moving into Essbase
    • Bringing EAL into Essbase by enhancing its core strength:  financial apps
    • Replicate EAL into Essbase
      • Financial Accounts dimension, member types, and behaviors
    • Integrated per plan
  • Post Load Processing
    • Post load script for data manipulation before it is stored in the cube
      • Think balances vs flow on periodicities
      • Any frequency submit, store in one
        • YTD, MTD, QTD comes in, periods get stored
        • Coming for Planning as well from forms
          • We don’t have to write calc scripts to do this
  • Dimension member properties
    • Text (!), arrgh, missed the rest
  • Cell status
    • How and when did a cell in the db get populated
      • Load, Calc, data entry, Dynamic
      • Transaction ID for the last update transaction
    • Available via calc scripts, AP, and MaxL
    • Will be available across all engine types
  • In-memory
    • On Exalytics, Essbase will be a pure in memory engine so no wait for I/O
      • Remain Exalytics only because cannot rely on commodity servers having enough RAM to do this
    • In memory aggregate views for ASO will not need to be stored on disk

EPM News News News (Oracle OpenWorld, day 2)

Planning

  • User-defined sandbox, grid improvements, instantaneous calculations (hellllllllllllooooo Hybrid Essbase)
  • Cloud innovations available for on premises
  • Planning Cloud will get the full suite of Planning modules
Planning demo now up – and yes, now I have a clue.  Barely.
  • Support for user sandbolxes
    • Auto calcs, auto save on change
    • Cloud and on-premises
  • Supports large data sets
    • Rapid forms, quick cell navigation (so quite an improvement), scrolling in all grids
  • User-defined client side calcs using familiar Excel syntax in the grid itself
Formulas can reference dimension members and persisted in Planning (I believe the data is persisted in Planning and the form calculations are persisted in Planning – this is not, I think, a way for users to create Planning members, although one could certainly argue that a custom, persisted set of calculations that writes back to Planning/Essbase is pretty nice)