Oracle Analytics Cloud Essbase: Build, Manage Apps and Cubes

Oracle Analytics Cloud Essbase: Build, Manage Apps and Cubes Certification Training Course Overview

Oracle Analytics Cloud Essbase: Build, Manage Apps and Cubes training course is designed for enhancing knowledge of Oracle Analytics Cloud – Essbase. In this training class, you will learn the core principles of designing, creating and managing cubes and you will also learn loading data and executing scripts in OAC-Essbase.

Course Objective:

  • Work with application workbook
  • Create Cubes from Tabular Data
  • Create and Manage Cube Outlines in Cloud Service
  • Executing scripts in OAC-Essbase

Target Audience:

  • Analyst
  • Business Analyst
  • Data Analyst

Oracle Analytics Cloud Essbase: Build, Manage Apps and Cubes (24 Hours) Download Course Contents

Live Virtual Classroom
Group Training 1700 Date On Request
1-on-1 Training (GTR) 1950
4 Hours
8 Hours
Week Days
Week End

Start Time : At any time

12 AM
12 PM

GTR=Guaranteed to Run
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Special Solutions for Corporate Clients! Click here Hire Our Trainers! Click here

Course Modules

Module 1: Overview of Oracle Analytics Cloud Essbase
  • Introduction to Oracle Analytics Cloud Essbase
  • Designing and Creating Cubes with Application Workbooks
Module 2: Navigate OAC Essbase
  • Getting Started with OAC Essbase
  • Configure Smart View and Cube Designer
Module 3: Create and Analyze Cubes with Application Workbooks
  • Essbase.Cube Worksheet
  • Dimension Worksheets
Module 4: Create Cubes from Tabular Data
  • Working with Tabular Data
  • Transform Data to Cube
Module 5: Create and Update Cubes in Cube Designer
  • Using Cube Designer
  • Incremental Cube Updates in Cube Designer
Module 6: Manage Cube Outlines in Cloud Service
  • Adding dimensions and members to outlines
  • Create and execute a calculation script
Module 7: Export and Modify Metadata and Data
  • Export application workbooks
  • Export Essbase on-premises cubes
Module 8: Load Data and Files to a Cube
  • Load data from application workbooks
  • Load data in the cloud service
Module 9: Calculate and Audit Data in a Cube
  • Create and execute calculation scripts
  • Set application-level tracing and auditing
Module 10: Model Data with Private Scenarios
  • Describe scenario management, scenarios, and sandboxes
  • Create scenarios and add sandboxes
Module 11: Create Partitions to Link Cubes
  • Define transparent partitions and replicated partitions
  • Describe the use of the @XREF and @XWRITE functions
Module 12: MaxL and the Command Line Interface (CLI
  • Create and run MaxL scripts
  • Use the command-line interface
Download Course Contents

Request More Information

Course Prerequisites
  • Basic Computer Knowledge.
  • Discuss the features and benefits of Oracle Analytics Cloud - Essbase (OAC Essbase)
  • Define identity domains and services instances
  • Describe user-level and application-level roles in OAC Essbase
  • Explain how application workbooks, Smart View, and Cube Designer are used in OAC Essbase