Build Essbase Reports with the Spreadsheet Add-In

PT7747
Summary
This course teaches students how to create spreadsheet reports and perform analyses using the core Essbase commands. It teaches how to use the core functionality of the Essbase Spreadsheet Add-in, as well as important multidimensional concepts and ad-hoc reporting techniques.
Prerequisites
Students should be proficient with Microsoft Excel.
Duration
3 Hours/Lecture
Audience
This course is designed for end-users, analysts, and designers of Essbase reports.
Topics
  • OLAP & multidimensionality concepts
  • Overview of the Sample database and outline concepts
  • Connect to an Essbase database
  • Types of reports and methods of creating them
  • Retrieve and manipulate data
  • Use dimension name aliases in reports
  • Zoom and pivot commands
  • Essbase options
  • Keep and Remove Only commands
  • Flashback

Related Scheduled Courses