Design Essbase ASO Databasee

Learn to develop Essbase aggregate storage databases. This course is your next step toward success as an Essbase professional. It is designed to build on a firm foundation in basic database planning and development to create full-scale Essbase deployments. You will learn 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. You will finish with an in-depth discussion of time intelligence.
Course Details
Training Code: WTESS103
Available as : Classroom & In Company course
Duration: 24 Hours
Prerequisites:
  • Oracle Essbase: Bootcamp
  • Oracle Hyperion Smart View for Essbase

Design Essbase ASO Databasee


  • 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

Home | Trainings | Services | Technologies | Careers | Contact us

Facebook LinkedIn
(+91) 20 60 123456

Copyright © 2011 Wishtree Technologies LLP. All rights reserved.

x

Request A Training

x

Training Enquiries