Oracle Analytics Cloud Essbase: Build, Manage Apps and Cubes - Fudgelearn

Oracle Analytics Cloud Essbase: Build, Manage Apps and Cubes

Date
Time
Price
27-Aug-2019
03:00 PM BST - 11:00 AM BST
£ 1497
04-Feb-2020
03:00 PM GMT - 11:00 AM GMT
£ 1497
08-Apr-2020
03:00 PM BST - 11:00 AM BST
£ 1497
Date
Time
Price
Location
Date
Start time
Price
Location
Version title
Price

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.

  • Analyst
  • Business Analyst
  • Data Analyst
  • 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

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
Need help finding the right course

Having problem finding the course you’re looking for? Get in touch.

£ 1497
3 Days
Live Virtual Class
3 Events available
Share this Course
Get in touch
If you would like to find out how we can help you, please get in touch
Book a meeting
We offer free consultation if you’re keen to find out what course fits the best for you. Use the link below to schedule a meeting with us.
Print
Use the links below to print the details.
Convince your boss

Oracle Analytics Cloud Essbase: Build, Manage Apps and Cubes

Course Overview

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.

Virtual Class
3 Days
Date
Start time
Price
Location
27-Aug-2019
03:00 PM BST
£ 1497
Live Virtual Class
04-Feb-2020
03:00 PM GMT
£ 1497
Live Virtual Class
08-Apr-2020
03:00 PM BST
£ 1497
Live Virtual Class
Audience
  • Analyst
  • Business Analyst
  • Data Analyst
Objectives
  • 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
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