The future of IBM Maximo: Work Centers and Inspections Can Transform Your Business

closeClose

Oracle Analytics Cloud Essbase: Build, Manage Apps and Cubes

  • Tuition USD $2,316
  • Reviews star_rate star_rate star_rate star_rate star_half 486 Ratings
  • Course Code D100499GC10
  • Duration 3 days
  • Available Formats Virtual

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

How do I enroll?

A comprehensive listing of ExitCertified courses can be found here. You can register directly for the required course/location when you select "register". If you have any questions or prefer to speak with an ExitCertified education consultant directly, please submit your query here. A representative will contact you shortly.

How do I pay for a class?

You can pay at the time of registration using credit card (Mastercard/Visa/American Express) cheque or PO.

What if I have training credits?

ExitCertified honors all savings programs from the partners we work with. ExitCertified also offers training credits across multiple partners through our FLEX Account.

When does class start/end?

Classes begin promptly at 9:00 am, and typically end at 5:00 pm.

Lunchtime?

Lunch is normally an hour long and begins at noon. Coffee, tea, hot chocolate and juice are available all day in the kitchen. Fruit, muffins and bagels are served each morning. There are numerous restaurants near each of our centers, and some popular ones are indicated on the Area Map in the Student Welcome Handbooks - these can be picked up in the lobby or requested from one of our ExitCertified staff.

How can someone reach me during class?

If someone should need to contact you while you are in class, please have them call the center telephone number and leave a message with the receptionist.

What languages are used to deliver training?

Most courses are conducted in English, unless otherwise specified. Some courses will have the word "FRENCH" marked in red beside the scheduled date(s) indicating the language of instruction.

I took the AWS training class. Instructor was fantastic and the labs were fun and easy to understand. I had no issue! :)

Really nice and helpful staff! Office has well thought out interior design and plenty of snacks and drinks and coffee.

Tommy was a great instructor. We relied on this class to develop our understanding, and we were very happy with the result.

Gave directions/document with great places to eat and area was very clean Free parking and food in kitchen in the morning

The presenter was knowledgeable and professional. The duration of the course, the pace and venue was suitable also

4 options available

undo
  • Aug 11, 2020 Aug 13, 2020 (3 days)
    Location
    Virtual
    Language
    English
    Time
    07:00 AM 15:00 PM PST
    Enroll
    Enroll
  • Sep 8, 2020 Sep 10, 2020 (3 days)
    Location
    Virtual
    Language
    English
    Time
    09:00 AM 17:00 PM CST
    Enroll
    Enroll
  • Oct 5, 2020 Oct 7, 2020 (3 days)
    Location
    Virtual
    Language
    English
    Time
    07:00 AM 15:00 PM GMT
    Enroll
    Enroll
  • Nov 17, 2020 Nov 19, 2020 (3 days)
    Location
    Virtual
    Language
    English
    Time
    07:00 AM 15:00 PM PST
    Enroll
    Enroll
Contact Us 1-800-803-3948
Contact Us Live Chat
FAQ Get immediate answers to our most frequently asked qestions. View FAQs arrow_forward