ASO & MDX Essentials (1 day)


Essbase On Premises Developers, System Administrators

Learning Objectives

For companies that are planning to or are already using Aggregate Storage Option (ASO), this class delves deep into ASO and MDX in order to familiarize students with the capabilities and limitations of ASO databases.

Course Description

Originally part of the 123OLAP Advanced Essbase course, much of the class is organized so that people familiar with Block Storage can quickly convert that knowledge into working with ASO databases. We start by covering key differences with Block Storage databases and then show you how to convert from BSO to ASO for cubes where this may be appropriate. The last section of the course covers the essentials of MDX – the new formulas and query language introduced in System 9. We take formulas and logic we introduced in our Applied Calculation section (for BSO databases) and convert them to MDX so that you can see the solutions side by side.

Course Information

Audience: Implementation consultants, developers, system administrators.

Duration: 1 day

Pre-requisites: Some experience administering or developing in Essbase

Delivery method:

  • Classroom: Private - In Person or Live Online (contact us to schedule)

Advanced preparation: None

Recommended CPE credits: 8 credits

Day Summary

Day 1: ASO architecture and aggregations, MDX for ASO – solving similar problems as presented in BSO using MDX formulas, ASO allocations – write back calculations using ASO allocations, MDX for report writing out of Essbase, Overview of Essbase, Essbase Admin Console introduction, building outlines manually, setting dimension and member properties, best practices of design, Smart View ad hoc reporting.


Day 2: Load rules for metadata updates, load rules for loading actual data, architecture and calculation fundamentals.


Day 3: ASO Architecture – views, building an ASO database, key differences with BSO.


Day 4: BSO calculation fundamentals, advanced BSO calculations, MDX for ASO.


Day 5: Essbase security, automation with MaxL, partitioning between cubes, optimization and configuration settings.

Detailed Agenda

ASO Fundamentals

  • Understanding how ASO is different than BSO

  • Converting from BSO to ASO

  • Aggregations in ASO


ASO Aggregations and modeling

  • Aggregation tuning and settings

  • Getting around ASO limitations

  • Time design

  • Balance sheet members



  • MDX introduction

  • Syntax rules and different alternatives

  • Advanced common formula requirements:

  •     YTD/QTD solutions

  •     Variance analysis

  •     Relationship based ratios

  •     Working with ranges of members

  •     Cross-referencing dimensions

  •     Recursive functions

  • Understanding solve order

  • ASO allocations