The right foundations changes everything
The Digital Renaissance


Oracle Essbase 21c Calc Scripts for Mere Mortals

Aug 20, 2024 9:00 am CST

Registration Deadline

Aug 13, 2024




Aug 20, 2024
9:00 am CST


Live Virtual Classroom Training

Course Description:

The Essbase Block Storage calc engine is one of its most powerful features. Sadly, most people are just using simple member formulas and running default aggregation calcs.  To unlock the true power of Essbase BSO, you need to tap into Essbase Calc Scripts and the 350+ functions that make up the Essbase Calc Script language. In this session, we’ll go way beyond the basics (like CALC ALL, CALC DIM, and SET) and get into complex topics such as allocation, data cleansing and cross-dimensional calculations. We also give you a few tips and tricks on optimizing Calc Scripts and we’ll make sure to explain why that whole “FIX on sparse, IF on dense” mantra is wrong half the time.  This knowledge is gained through material review and hands on exercises. This course is recommended for Oracle Essbase Administrators.

Course Agenda

Review the outlines

Review the outlines

Course Outline:

    • Calc Scripts Defined
    • Simple Calculations
    • IF/Elself/Else
    • Fix Statements
    • Cross Dimensional Operators

Related Courses:

Thank you for your interest in our training sessions!

You should have been directed to a registration page to complete the payment process.
If you need additional assistance, please contact us at [email protected].

Start your training journey now
and sign up today

Let’s get started