ORACLE ESSBASE

HomeORACLE ESSBASE

ORACLE ESSBASE

Oracle Essbase 11.1.2: Deploy Aggregate Storage Databases
You learn the principles of aggregate storage database design, then how to build, load, report from, and manage aggregate storage databases, constructing the sixteen-dimension in-class database through a series of guided exercises.
Learn to:                                                

  • Design, develop, and deploy aggregate storage databases
  • Manage aggregate storage databases
  • Construct variance, mix, and other member calculations using MDX
  • Implement time intelligence for time period reporting
  • Describe custom calculations and allocations in aggregate storage databases

Additional topics give you an in-depth view of (and hands-on practice in) important elements of ASO development, including complex member formulas, time intelligence, partitioning.


Oracle Essbase 11.1.2: Calculate Block Storage Databases
This Oracle Essbase Calculate Block Storage Databases training teaches you the principal techniques and theories for the design of calculations in block storage databases with Essbase Release 11.1.2.3. Expert Oracle University instructors will review database structure and configuration and teach you basic calculation building blocks, including FIX and IF statements.
Learn To:

  • Describe Essbase and block storage database structures.
  • Develop and test calculation scripts.
  • Develop advanced calculations.
  • Optimize databases though dynamic calculations.
  • Normalize and allocate data.

Oracle Essbase  Bootcamp
Oracle Essbase Bootcamp teaches you the principal techniques and theories to design Essbase block storage databases. Block storage databases are deployed independently for budgeting, forecasting and planning, and as the underlying data storage and analytic engine for Hyperion Planning applications.
Learn To:

  • Create block storage databases.
  • Build rules files.
  • Analyze data with Smart View.
  • Create basic calculations.
  • Extend analysis capabilities.
  • Create a database outline, load data into the database and analyze data with Smart View.
  • Perform advanced analysis on the database by implementing varying attribute dimensions and typed measures.