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.
