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 1950
Group Training Date On Request
1-on-1 Training (GTR)
4 Hours
8 Hours
Week Days
Weekend

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

Top Trending Technologies

 Cloud Computing Certification Training Courses
 IT Security and Cybersecurity Certification Courses
 Fundamentals Training and Certification Courses
 System Administration Training and Certification Courses
 Cloud Architect Certification Training Courses
 CRM Training and Certification Courses
 Big Data Analytics Courses & Certification Training
 Data Analytics Certification and Training Courses
 Security Testing Training & Certification Courses
 Programming Courses Training and Certification

FAQ's