Skip to main content
Request a Training Proposal

Instructor-led training

Oracle Essbase 11.1.2: Calculate Block Storage Databases (11.1.2.3) Training in Peekskill, New York

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.

Request a Training Proposal View Course Outline

What you'll learn

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.

Prerequisites

Oracle Essbase 11.1.2 Bootcamp

Course Outline

Essbase Overview
- Essbase
- Essbase Database Types
- Business Scenario and Training Environment Overview
- Block Storage Calculation Overview
 
Data Storage and Calculation
- Data Storage and Calculation Fundamentals
- Database Statistics
- Data Block Creation
- Database Calculation Process
 
Calculation Script Basics
- Calculation Script Organization
- Implementing a Script Development Process
- Intelligent Calculation
 
Dynamic Calculation Overview
- About Dynamic Calculation
- Dynamic Calculation Storage Options
- Design Considerations for Dynamic Calculation
- Design Considerations for Rates and Percentages
 
Controlling the Calculation Process
- Controlling Top-Down Calculation
- Performance Considerations
- Creating Complex Conditionals
 
Copying and Clearing Data
- Copying Data
- Clearing Data with CLEARDATA
- Clearing Data with CLEARBLOCK
 
Developing Advanced Calculations
- Creating Calculation Variables
- Referencing Members Dynamically
 
Developing Analytic Calculations
- Typed Measures Overview
- Creating Typed Measures
- Calculating with Typed Measures
 
Multidimensional Dynamic Calculations
- Dynamic Calculation Order
- Optimization Guidelines
 
Normalizing Data
- Loading Data to Upper-Level Members
- Planning Data Normalization
- Normalizing Rates and Drivers
 
Performing Advanced Allocations
- Allocating Data
- Creating Multiple-Database Calculations
 
Appendix: Essbase Architecture
- Essbase Architecture Overview
- Essbase Components by Tier

Training locations

Oracle Essbase 11.1.2: Calculate Block Storage Databases (11.1.2.3) training across the U.S. and beyond.

We provide Oracle Essbase 11.1.2: Calculate Block Storage Databases (11.1.2.3) training onsite and live online for organizations throughout the United States and internationally.

View all Oracle Essbase 11.1.2: Calculate Block Storage Databases (11.1.2.3) training locations

Train your team with HSG

Private, instructor-led training customized for your organization.

  • Onsite or live online delivery
  • Customized curriculum
  • Training for groups of 3 or more
  • Flexible scheduling
  • Experienced instructors
Request a Training Proposal

Questions? Call us at 303.377.6176
or email info@hartmannsoftware.com

Browse all Oracle courses →

Ready to train your team?

Let's customize this training for your organization.

Tell us about your employees, your goals, and your preferred schedule. We'll prepare a training proposal covering scope, delivery format, and pricing.

Request a Training Proposal

or call 303.377.6176