Duration : 24 hours
Prerequisites :
– Oracle Essbase: Bootcamp
– Oracle Hyperion Smart View for Essbase

Course Overview

This course has been designed to teach you how to develop Essbase aggregate storage databases and help you take the first step towards becoming a success in this field. This course will give you a firm foundation in basic database planning and development to create full-scale Essbase deployments. You will be taught how to convert existing block storage database outlines to aggregate storage and how to create aggregate storage databases. You will also learn about database partitioning as it relates to aggregate storage databases and about MDX for building member formulas.

Course Content

Deploy Aggregate Storage Database

  • Essbase Overview
  • Creating Aggregate Storage Databases
  • Loading and Aggregating Data
  • Managing Aggregate Storage Databases
  • Partitioning Overview
  • Creating Database Partitions
  • Creating Basic MDX Queries
  • Converting Block Storage Member Formulas
  • Creating Basic MDX Formulas
  • Time Intelligence Overview
  • Building Time Dimension Models
  • Loading Data Mapped to Dates
  • Creating Time Period Reports
  • Calculating Time-Based Metrics
  • Time Balance Calculations

Schedule A Training

Name *

Company Name*

Number

Email*

Training Location*

Prefered Start Date

Your Message