Essbase: Enablement for Project Teams (2 days)

Audience

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

 

Storage

• 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

Register

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.

123EPM

Address: 2425 N Center St, Suite 240, Hickory, NC 28601

Tel. 828-278-8588

linkedin button.png