About this course:

This Oracle Essbase 11.1.2: CBSD 11.1.2.3 course provides you the knowledge and understanding of the theories and principal techniques for designing the calculations in block storage databases through Essbase Release (11.1.2.3). Professional Oracle University trainer will examine database configuration and structure and provide you fundamental calculation building blocks, like IF and FIX statements.

Learn To:

• Create and review calculation scripts.
• Enhance databases by dynamic calculations.
• Create advanced calculations.
• Define block storage database and Essbase structures.
• Allocate and normalize data.

Benefits to You:

By appearing at this course, you will learn the calculation script development methods and way to rectify usual miscalculations. You will study the methods for effective leverage dynamic calculations to improve database efficiency and develop advanced calculation scripts, like, multidimensional range calculation, cross-database calculations, and allocations. Through involvement in hands-on practice sessions and design discussions. You will enhance your skills and knowledge of major Essbase concepts.

Note: This course is designed for those people who are using Oracle Essbase (11.1.x) or Hyperion Essbase Analytics (9.3.1).

Course Objective:

• Knowledge of practical methodology for testing and developing block storage calculations, with simple to the complex.
• Emphasis calculations in particular subsets of data.
• Learn the mechanisms through which Essbase calculates and stores data in block storage databases.
• Learn how to use the dynamic calculation to optimize performance and improve the database.
• Examine various methods for planning and implementing multidimensional allocations.
• Understanding of default database calculation order and examine the relation of block storage data structures.
• Analyze the several calculation variables and implement those variables in calculation scripts.

Audience:

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

Prerequisite:

• Oracle Essbase (11.1.2) Bootcamp