Loading Course Schedule...
PT10631
Training Summary
During this four-day course, you will learn the principal techniques of Essbase Analytics database design. From start to finish, you will learn how to implement an Essbase database. We will discuss the role of OLAP in BPM, analyze data in Excel while constructing and troubleshooting a variety of reports, design and build database outlines, create load rules to automate dimension builds and data loads, create basic database calc scripts, and assign security. Hands on exercises and a case study will give you the opportunity to see first-hand how to implement Essbase Analytics. This course is tailored for new Essbase administrators. The course briefly touches on Visual Explorer & Query Designer, Smart View, and MDX.
Prerequisites
Prior to this course, students should have experience with Excel.
Duration
4 Days/Lecture & Lab
Audience
This course is designed for new Essbase administrators.
Course Topics
- Essbase Introduction
- Demonstration
- Designing an Essbase Database
- Excel Add in
- Building an Essbase Database
- Building Dimensions Dynamically
- Attribute Dimensions
- Understanding Essbase Database Structures
- Loading Data
- Consolidating and Calculating Data
- Calculation Features
- Calc Script Introduction
- Report Scripts
- Maxl / Automation
- Security
- Enterprise Analytics / ASO Introduction
- Currency Conversion
- Administration
- Design Tips
- Business Case