Essbase: Enablement for Project Teams (2 days)


Project Managers, Implementation Teams, Stakeholders.

Learning Objectives

Gain an understanding of the block storage capabilities of Essbase database software and the multidimensional design of common data sources.

Course Description

An overview of Essbase, ideal for Project Managers and Administrators alike. Learn about application and database structure, dimensional properties and the key design considerations when working with Essbase. Topics include the setup and navigation of the client interface, the creation of new applications and databases, loading data through load rules, formula design and ad hoc spreadsheet analysis.

Course Information

Audience: Project Managers, Implementation Teams, Stakeholders

Duration: 2 days

Pre-requisites: None

Delivery method: Classroom: Private - In Person or Live Online (contact us to schedule)

Advanced preparation: None

Recommended CPE credits: 14 credits 

Day Summary

Day 1: Overview, multidimensionality, block storage, navigation, dimension setup, storage types.


Day 2: Typed measures, format string, attributes, Smart View Add-In for Microsoft Office.

Detailed Agenda

Essbase Overview

• Understanding Essbase
• Multidimensionality
• The Essbase Administration Services console


Creating Applications

• Application and database setup

• Key dimensions
• Member properties



• Block storage
• Dense and sparse dimensions

• Storage types


Load Rules

• Dimension building

• Data loading
• Parent/child loads

• Level build loads

• Incremental updates

• Shared members


Typed Measures & Attributes

• Text members
• Date members
• Format string
• Attribute associations

• Varying attributes


Smart View

• Smart View panel
• Ad Hoc Analysis
• Formatting and filtering

• Query Designer
• Functions


This course is offered as private training only, through our strategic partnership with Keyteach, using state-of-the-art technology and a live environment for hands-on labs. Contact us to schedule a private class.

Color logo - no background.png