Oracle Essbase 11.1.2: Deploy Aggregate Storage Databases

Level

Oracle Essbase 11.1.2: Deploy Aggregate Storage Databases

Aikona
Logo Aikona

Need more information? Get more details on the site of the provider.

Starting dates and places

There are no known starting dates for this product.
  • View related products with starting dates: Oracle.

Description

Special Notices

Please note that Oracle courses running at London training centres are subject to a 10% surcharge.

Overview

You learn the principles of aggregate storage database design, then how to build, load, report from, and manage aggregate storage databases, constructing the sixteen-dimension in-class database through a series of guided exercises.

Learn to:

  • Design, develop, and deploy aggregate storage databases
  • Manage aggregate storage databases
  • Construct variance, mix, and other member calculations using MDX
  • Implement time intelligence for time period reporting
  • Describe custom calculations and allocations in aggregate storage databases

Additional topics give you an in-dep…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: Oracle, CompTIA A+ / Network+ / Security+, IT Security, Retail (Management), and Security.

Special Notices

Please note that Oracle courses running at London training centres are subject to a 10% surcharge.

Overview

You learn the principles of aggregate storage database design, then how to build, load, report from, and manage aggregate storage databases, constructing the sixteen-dimension in-class database through a series of guided exercises.

Learn to:

  • Design, develop, and deploy aggregate storage databases
  • Manage aggregate storage databases
  • Construct variance, mix, and other member calculations using MDX
  • Implement time intelligence for time period reporting
  • Describe custom calculations and allocations in aggregate storage databases

Additional topics give you an in-depth view of (and hands-on practice in) important elements of ASO development, including complex member formulas, time intelligence, partitioning, and the new features in Release 11.1.2, calculation templates and allocations.

Audience

  • Sales Consultants
  • Technical Consultant
  • Support Engineer
  • Developer

Prerequisites

Required Prerequisites:

  • Knowledge of Microsoft Windows and Excel
  • Knowledge of principles from Oracle Essbase Bootcamp course
  • Oracle Essbase 11.1.2 Bootcamp

Delegates will learn how to

  • Create ASO databases
  • Load data into ASO databases
  • Aggregate ASO data
  • Design aggregate storage (ASO) databases
  • Manage ASO databases
  • Construct member formulas
  • Build time-intelligent models
  • Describe custom calculations and allocations in aggregate storage databases

Course Outline.

Essbase Overview

  • The Oracle Enterprise Performance Management System
  • The Oracle BI Foundation Suite
  • The Essbase analytic solution

Aggregate Storage Overview

  • Aggregate storage key characteristics and design considerations
  • Understanding the aggregate storage production cycle
  • Creating aggregate storage outline hierarchies

Designing Data Descriptor Dimensions

  • Understanding data descriptor dimensions
  • Designing time, scenario, and accounts dimensions

Designing Business View Dimensions

  • Understanding business view dimensions
  • Using attributes in database design
  • Designing primary and secondary hierarchies

Loading Data

  • Understanding the aggregate storage data loading process
  • Using data load buffers
  • Loading data incrementally

Creating Reports with Smart View

  • Understanding the Smart View architecture and user interface
  • Connecting to data sources
  • Working with shared and private connections

Aggregating Data

  • Understanding the data aggregation process
  • Optimizing aggregations
  • Designing and running aggregations with the Aggregation Design wizard

Managing Aggregate Storage Databases

  • Managing tablespaces
  • Exporting aggregate storage data
  • Optimizing data compression
  • Managing storage caches
  • Optimizing outline paging
  • Understanding disk space management options
  • Backing up aggregate storage applications
  • Viewing database statistics

Creating Basic MDX Queries

  • MDX Overview
  • Understanding MDX formula components and structure
  • Identifying dimensions and members in MDX
  • Identifying tuples and sets

Creating MDX Formulas

  • Using Member Formula Editor
  • Creating mix calculations
  • Using MDX conditional calculation tools
  • Deriving variances

Time Intelligence Overview

  • Understanding the benefits of time intelligence
  • Establishing time intelligence in aggregate storage applications
  • Using the Create Date-Time Dimension wizard

Building Time Intelligent Models

  • Creating a date-time dimension
  • Using standard calendar types
  • Defining member date ranges

Loading Data Mapped to Dates

  • Identifying date hierarchies
  • Performing date-based data loads
  • Using date-string formats

Creating Time Period Reports

  • Identifying linked attributes
  • Understanding periodic associations
  • Creating linked attribute reports

Calculating Time-Based Metrics

  • Understanding time dimension designs
  • Creating analytics dimensions
  • Calculating time-based metrics
  • Using MDX date functions

Time Balance Calculations

  • Using time balance tags
  • Using flow tags

Partitioning Overview

  • Identifying data transfer methods
  • Understanding database partition types
  • Identifying the best partition type to use
  • Resolving partition overlaps
  • Following partitioning guidelines

Creating Database Partitions

  • Designing partitions
  • Creating partitions
  • Evaluating partition designs

Creating Custom Calculations

  • Understanding the workflow for creating custom calculations
  • Specifying calculation criteria
  • Writing and executing custom calculations

Creating Allocations

  • Understanding the workflow for creating ASO allocations
  • Specifying allocation criteria
  • Specifying allocation and rounding methods
  • Executing allocations
There are no reviews yet.
  • View related products with reviews: Oracle.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate £1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.