Loading Course Schedule...
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.
Prior to this course, students should have experience with Excel.
4 Days/Lecture & Lab
This course is designed for new Essbase administrators.
- Essbase Introduction
- 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
- Enterprise Analytics / ASO Introduction
- Currency Conversion
- Design Tips
- Business Case