PDP Url

Oracle Essbase 11.1.2: Calculate Block Storage Databases (11.1.2.3) (OR-ESS-CBSD)

This Oracle Essbase 11.1.2: Calculate Block Storage Databases (11.1.2.3) training teaches you how to develop calculations for Essbase 11.1.2.3 block storage databases. It's designed to give you a firm foundation in basic database structure and calculation.

Virtual

Learning Style

Intermediate

Difficulty

2 Days

Course Duration

Course Info

Download PDF

Certificate

See Sample

Buy Individually
About Individual Course:
  • Individual course plan gives you access to this course
$1,760.00
$1,760.00
/ Seat
This Oracle Essbase 11.1.2: Calculate Block Storage Databases (11.1.2.3) training teaches you how to develop calculations for Essbase 11.1.2.3 block storage databases. It's designed to give you a firm foundation in basic database structure and calculation.

Course Information

About this course:

This Oracle Essbase 11.1.2: Calculate Block Storage Databases (11.1.2.3) 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.

Benefits to You

By enrolling in this course, you'll become familiar with calculation script development methodology and how to correct common calculation errors. You'll learn how to effectively leverage dynamic calculations to optimize database performance and create advanced calculation scripts, such as allocations, cross-database calculations and multidimensional range calculations. By participating in design discussions and hands-on practice sessions, you'll reinforce your understanding of important Essbase concepts.

Please Note

This course is also suitable for customers using Hyperion Essbase Analytics 9.3.1 or Oracle Essbase 11.1.x.

Course Objective:

  • Gain an understanding of the mechanisms by which Essbase stores and calculates data in block storage databases.
  • Learn the default database calculation order and investigate how it relates to block storage data structures.
  • Learn practical methods for developing and testing block storage calculations, from the simple to the complex.
  • Understand where use of dynamic calculation can improve database and calculation performance.
  • Focus calculations on specific subsets of data.
  • Compare the different calculation variables available and implement variables in calculation scripts
  • Investigate different methods for implementing and planning multidimensional allocations.

Audience:

  • Database Administrators
  • Database Designers
  • Data Warehouse Analyst
  • Technical Consultant
  • Data Modelers
  • Business Intelligence Developer
  • Data Warehouse Developer
  • Data Warehouse Administrator

Prerequisite:

  • Oracle Essbase 11.1.2 Bootcamp

Outline

More Information

More Information
Brand Oracle
Subjects IT Ops & Management
Lab Access No
Technology Oracle
Learning Style Virtual Classroom
Difficulty Intermediate
Course Duration 2 Days
Language English

Reviews

Write Your Own Review
Only registered users can write reviews. Please Sign in or create an account

Contact A Learning Consultant


click here