Hands On Training

Oracle Essbase 11.1.2: Deploy Aggregate Storage Databases (OR-ESS-DASD)

via

QuickStart

Course Features

Duration

4 days

Delivery Method

Online

Available on

Lifetime Access

Accessibility

Desktop, Laptop

Language

English

Subtitles

English

Level

Intermediate

Teaching Type

Self Paced

Course Description

Through a series guided exercises, you will learn the basics of aggregate storage database design. Next, you will learn how to load, report from and manage aggregate storage databases. Finally, you will construct the 16-dimension in-class database by following a series of guided tasks.

Learn how to:

Construct, develop, deploy and maintain aggregate storage databases
Manage aggregate storage databases
Use MDX to calculate variance, mix, or other member calculations
Implement time intelligence for time period reporting
Define custom calculations and allocations within aggregate storage databases

You will also find additional topics that provide an in-depth look at (and practice in) key elements of ASO development such as complex member formulas and time intelligence.

Course Overview

International Faculty

Post Course Interactions

Instructor-Moderated Discussions

Skills You Will Gain

Prerequisites/Requirements

Knowledge of Microsoft Windows and Excel

Knowledge of principles from Oracle Essbase Bootcamp course

What You Will Learn

Aggregate ASO data

Build time-intelligent models

Construct member formulas

Create ASO databases

Describe custom calculations and allocations in aggregate storage databases

Design aggregate storage (ASO) databases

Load data into ASO databases

Manage ASO databases

Target Students

Developer

Sales Consultants

Support Engineer

Technical Consultant

Course Content

Expand all sections

Module 1: Essbase Overview

Module 2: Aggregate Storage Overview

Module 3: Designing Data Descriptor Dimensions

Module 4: Designing Business View Dimensions

Course Instructors

Tom Robertson

Data Science Enthusiast

Tom is an innovator first, and then a Data Scientist & Software Architect. He has integrated expertise in business, product, technology and management. Tom has been involved in creating category defi...

This Course Is Not Available In Your Country Or Region

Explore Related Courses