Calculate Essbase Databases

PT7748
Summary
This course builds on the knowledge learned in the courses Building Essbase Outlines, Essbase Dynamic Dimension Building, and Essbase Data Loading courses. Learn how to calculate the data loaded into an Essbase database using outline calculation and custom calculation scripts within the Essbase Administration Services (EAS) Console. This course is very hands-on, with practical examples and exercises that help the student build a complete application and database.
Prerequisites
Students should have experience with Essbase Data Loading or the knowledge of how to load data into an Essbase database. Also knowledge of dimension member properties would be helpful.
Duration
2 1/2 Hours/Lecture
Audience
This course is designed for analysts and designers of Essbase applications, database administrators, power users and support personnel.
Topics
  • Calculation methods
  • Calculation order
  • Calculation optimization
  • Two-pass calculation
  • Dynamic calculation
  • Calculation script editor
  • Calculate members
  • Calculate dimensions
  • Intelligent calculation
  • Calculate subsets of data
  • Calculation functions
  • Clear data
  • Copy data
  • Substitution variables

Related Scheduled Courses