Formerly called Essbase Power User, this 2-day Essbase Fundamentals course is geared towards users of Essbase and Smart View. We start with a general overview of Essbase terms and how they are commonly used. We then go through multi-dimensional modeling and design. Students learn to use the EAS Console to model out dimensions and to gain an understanding of how cubes are designed. In building out dimensions, we work through all the important storage properties (dynamic, stored, labels), aliases, adding formulas to members, and cover special properties that relate to Accounts and Time, specifically time balance, expense reporting, and YTD functionality.
After building out hierarchies, the class then uses load rules to load data. Once this data has been loaded, we begin to unravel the mystery of Block Storage cubes (Dense/Sparse) and dive into calculation fundamentals for consolidations. Along the way, students will have already learned some fundamentals of using Smart View to build ad hoc reports but we allocate more time to this and cover all the essential operations and options available to build reports with Smart View so that students can build reports from scratch.
build dimensions and hierarchies using EAS, understand the most important properties of members, load data using load rules, understand BSO architecture, and the process of consolidation of data using calculation scripts. Students will be able to build out Smart View ad hoc reports from scratch.
- Overview of Essbase
- Application Design Overview
- Modeling dimensions and best practices
- Member properties – aliases, storage properties
- Adding formulas to members
- Time Balance and Expense reporting solutions
- YTD/QTD solutions
- Smart View for Reporting
- Load Rules for Loading Data
- Essbase Administration Services (EAS)
- Architecture of Block Storage
- Calculation Fundamentals