Session : 1 – Overview of Oracle Essbase

  • Describe multidimensional analysis
  • Describe Oracle Essbase
  • Smart View

  • Describe Smart View
  • Retrieve Data using Smart View
  • Session : 2 – Essbase Application Creation Fundamentals

  • Perform manual outline creation
  • Build dimensions from sources
  • Perform initial data loads
  • Use calculations and aggregations
  • Assign security
  • Session : 3 – Aggregate Storage Databases

  • Describe when to deploy aggregate storage, block storage, or a combined solution
  • Convert block storage to aggregate storage
  • Create, load, and pre-aggregate aggregate storage databases
  • Employ database partitioning in combined block/aggregate storage solutions
  • Write member formulas using MDX
  • Perform management tasks for aggregate storage databases
  • Partition block and aggregate storage databases
  • Describe and implement aggregate storage design best practices
  • Describe multiple hierarchies and the use of Shared Members
  • Session : 4 – Block Storage Databases

  • Describe block storage calculations
  • Describe the default database calculation order
  • Describe data blocks
  • Session : 5 – Describe how data blocks are indexed

  • Interpret database statistics
  • Describe when data blocks are created
  • Describe the block storage database calculation process
  • Tune and optimize block storage databases
  • Describe and implement block storage design best practices
  • Describe BSO load techniques Working with Calculation Scripts
  • Identify correct and incorrect calculation script syntax
  • Describe calculation script behaviour for various ASO data structures
  • Describe calculation script behaviour for various BSO data structures
  • Design calculation scripts to meet specified requirements
  • Session : 6 – Essbase Administration

  • Describe the file Essbase.cfg and its settings
  • Describe the file Essbase.sec and its settings
  • Identify and interpret Essbase log files
  • Manage Essbase security via Administration Services
  • Manage Essbase security via Shared Services
  • Back up and recover Block Storage Databases
  • Automate database processes with MaxL
  • Describe and use substitution variables and location aliases
  • Session : 7 – Essbase Studio

  • Describe functionality of Essbase studio
  • Add and delete joins between tables
  • Create drill through reports

Thanks for the best ever Training. I did my Android Course here. Trainer is very good in knowledge. They provides the best ever Support to me.

Kaviya