Summer-Ready Savings: Find the Training Course You Need at a Price You'll Love

closeClose

Oracle Analytics Cloud Essbase: Build, Manage Apps and Cubes

Course Details
Code: D100499GC10
Tuition (USD): $2,316.00 • Virtual (3 days)

In this Oracle Analytics Cloud Essbase: Build, Manage Apps and Cubes course, you learn how to create, manage, and use your Analytics Cloud - Essbase applications and cubes. You will learn to work with Application workbooks, create a cube from tabular data, analyze data with Smart View, loading data and executing scripts in OAC-Essbase. Design discussions and hands-on activities help you practice the skills taught.

Learn How To:

  • Work with application workbook
  • Create Cubes from Tabular Data
  • Create and Manage Cube Outlines in Cloud Service
  • Executing scripts in OAC-Essbase
Benefits to You:
As a data analyst, you'll learn about the structure of an application workbook, how to create an application in the cloud service and provision a user to access and query the cube.

Skills Gained

  • 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

Who Can Benefit

  • Analyst
  • Business Analyst
  • Data Analyst

Course Details

Topics

Overview of Oracle Analytics Cloud Essbase

  • Introduction to Oracle Analytics Cloud Essbase
  • Designing and Creating Cubes with Application Workbooks

Navigate OAC Essbase

  • Getting Started with OAC Essbase
  • Configure Smart View and Cube Designer

Create and Analyze Cubes with Application Workbooks

  • Essbase.Cube Worksheet
  • Dimension Worksheets

Create Cubes from Tabular Data

  • Working with Tabular Data
  • Transform Data to Cube

Create and Update Cubes in Cube Designer

  • Using Cube Designer
  • Incremental Cube Updates in Cube Designer

Manage Cube Outlines in Cloud Service

  • Adding dimensions and members to outlines
  • Create and execute a calculation script

Export and Modify Metadata and Data

  • Export application workbooks
  • Export Essbase on-premises cubes

Load Data and Files to a Cube

  • Load data from application workbooks
  • Load data in the cloud service

Calculate and Audit Data in a Cube

  • Create and execute calculation scripts
  • Set application-level tracing and auditing

Model Data with Private Scenarios

  • Describe scenario management, scenarios, and sandboxes
  • Create scenarios and add sandboxes

Create Partitions to Link Cubes

  • Define transparent partitions and replicated partitions
  • Describe the use of the @XREF and @XWRITE functions

MaxL and the Command Line Interface (CLI)

  • Create and run MaxL scripts
  • Use the command-line interface
  • Introduction to Oracle Analytics Cloud – Essbase
  • Designing and Creating Cubes with Application Workbooks

Navigate OAC Essbase

  • Getting Started with OAC Essbase
  • Configure Smart View and Cube Designer

Create and Analyze Cubes with Application Workbooks

  • Essbase.Cube Worksheet
  • Dimension Worksheets

Create Cubes from Tabular Data

  • Working with Tabular Data
  • Transform Data to Cube

Create and Update Cubes in Cube Designer

  • Using Cube Designer
  • Incremental Cube Updates in Cube Designer

Manage Cube Outlines in Cloud Service

  • Adding dimensions and members to outlines
  • Create and execute a calculation script

Export and Modify Metadata and Data

  • Export application workbooks
  • Export Essbase on-premises cubes

Load Data and Files to a Cube

  • Load data from application workbooks
  • Load data in the cloud service

Calculate and Audit Data in a Cube

  • Create and execute calculation scripts
  • Set application-level tracing and auditing

Model Data with Private Scenarios

  • Describe scenario management, scenarios, and sandboxes
  • Create scenarios and add sandboxes

Create Partitions to Link Cubes

  • Define transparent partitions and replicated partitions
  • Describe the use of the @XREF and @XWRITE functions

MaxL and the Command Line Interface (CLI)

  • Create and run MaxL scripts
  • Use the command-line interface
Contact Us 1-800-803-3948
Contact Us Live Chat
FAQ Get immediate answers to our most frequently asked qestions. View FAQs arrow_forward