Essbase ASO Implementation Training Classes And Essbase Course Trainer  BISP 

60% Complete Courses » Essbase ASO Implementation
  • Course Content
  • Course Overview
  • Training Schedule
  • Demo Video
  • Learning Material
  • Register

Essbase Overview

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

Designing Business View Dimensions

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


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

Creating MDX Formulas

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

Loading Data Mapped to Dates

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

Time Balance Calculations

  • Using time balance tags
  • Using flow tags

Creating Custom Calculations

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

Aggregate Storage Overview

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

Loading Data

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

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

Time Intelligence Overview

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

Creating Time Period Reports

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

Partitioning Overview

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

Creating Allocations

  • Understanding the workflow for creating ASO allocations
  • Specifying allocation criteria
  • Specifying allocation and rounding methods
  • Executing allocations

Designing Data Descriptor Dimensions

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

Creating Reports with Smart View

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

Creating Basic MDX Queries

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

Building Time Intelligent Models

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

Calculating Time-Based Metrics

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

Creating Database Partitions

  • Designing partitions
  • Creating partitions
  • Evaluating partition designs
Course Id:
Course Fees:
241 USD