Training

Oracle Essbase 21c Fundamentals for Admins

Date
On-Demand
Cost
$2500
Location
Live Virtual Classroom Training

Course Description:

Essbase is an amazing technology solution that allows companies to store and calculate data quickly. Using Smart View, Essbase provides data quickly to users using a common Excel interface. This Cloud solution will reduce your analytics and administration time, increase the timeliness of information, draw out key information elements important to your organization, and improve business decisions.

This training course will walk you through how to build an Essbase 21c cube from start to finish. We’ll also cover both web and Excel interfaces and how to maintain cubes. Knowledge is gained through material review and hands-on exercises. This course is tailored for new Essbase administrators with no Essbase experience.

Course Outline:

Introduction to Essbase 21c
Smart View Basics
  • Connecting to Essbase
  • Ad hoc analysis (zoom, slice, and dice), member selection, and Smart View options
Essbase Fundamentals
  • Cubes, dimensions, members, hierarchies, generations, and levels
  • ASO, BSO, and hybrid
  • Member properties and dimension properties
Build an Essbase cube with Cube Designer & application workbooks in Excel
  • Cube Designer ribbon
  • Application workbook definition
  • Build, update, and load a cube
  • Build a cube using unstructured data
Navigate the web Interface and build an Essbase cube via the web interface
  • Update dimensions
  • Available options to maintain dimensions
  • Update dimensions from application workbook
  • Dimension build rules
Load Data
  • Available options to maintain dimensions
  • Load data from application workbook
  • Data load rules
Build Calc Scripts and Calculate Data
  • Calc script basics
  • Build a calc script
Basics of Security
Administer and Automate
  • Basics of administrator tools and jobs console

Related Courses:

  • Oracle Essbase 21c Calc Scripts for Mere Mortals
  • Oracle Cloud EPM Planning Fundamentals for End Users
  • Oracle Cloud EPM Financial Consolidation & Close Fundamentals for Admins
  • Oracle Cloud EPM Narrative Reporting Fundamentals