ASO & MDX Essentials (1 day)
Essbase On Premises Developers, System Administrators
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.
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.
Audience: Implementation consultants, developers, system administrators.
Duration: 1 day
Pre-requisites: Some experience administering or developing in Essbase
Classroom: Private - In Person or Live Online (contact us to schedule)
Advanced preparation: None
Recommended CPE credits: 8 credits
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.
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
Balance sheet members
Syntax rules and different alternatives
Advanced common formula requirements:
Relationship based ratios
Working with ranges of members
Understanding solve order