Oracle Essbase (21c): Bootcamp Training Course
Duration
5 days (35 CPE credits)
Audience
Implementation consultants, developers, system administrators
Course Summary
Learn about the design of Essbase 21c databases, explore Essbase multidimensionality, the loading and manipulation of data through calculation scripts and how to maintain and optimize Essbase databases. Discover the modern browser-based UI for management and administration, explore Cube Designer plugin for Smart View, and learn about platform features such as connections/data sources.
How Can I Take this Course?
You can search for scheduled course dates for your time zone or you can request a private class for your team:
Scheduled Course Dates
Learning Objectives
By the end of this course learners will be able to:
- Identify the key differences between ASO and BSO databases
- Explain how to import existing metadata and configure enhanced reporting capabilities
- Critique how Essbase databases can be optimised
- Recognize the various methods for loading and entering data to the system
- Generate basic reports, spreadsheets and dashboards for entering and reviewing data
- Implement calculation scripts to perform targeted calculations
Course Description
This course covers everything you'll need to know to design and maintain Essbase Block Storage (BSO) and Aggregate Storage (ASO) databases. No prior knowledge is assumed. Learn the primary methods for the design of Essbase block storage databases.
Understand Essbase multidimensionality, dense and sparse settings, building outlines with load rules, maintaining the Essbase environment, creation and calculation of data blocks, storage types, dynamic calc shared members, the order of operations, member formulas, dynamic calculations, two-pass calcs and sparse rollups.
The course also covers detailed information about database outlines, loading data and analysis within a spreadsheet environment. There's also focus on the creation and optimisation of calculation scripts and the backup and system administration of the system.
Discover the Essbase 21c modern browser-based UI for management and administration, explore the new Cube Designer plugin for Smart View, and learn about new platform features such as connections/data sources, new security roles, dynamic filters, and more.
Scheduled Course Dates
Course title: Oracle Essbase (21c): Bootcamp
Duration: 5 days
Audience: System administrators, developers and implementation consultants
Pre-requisites: None
Delivery method: Group Live and Group Internet-Based
Advanced preparation: None
Recommended CPE credits: 35 credits - computer software and applications
Programme level: Intermediate
