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 customers with the capabilities and limitations of ASO databases. Usually sold as an add-on 1 day to the Applied Workshop class, 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.
Aggregate Storage Option Basics
In this section, we cover the ASO basics. We start by uncovering the architecture and stepping through the limitations of ASO databases so that developers can learn to identify the best fits for either ASO or BSO databases. We walk through the process of converting an existing BSO database outline into an ASO outline. We wrap up this section by loading data and performing an Aggregation on the database. Here again, we focus attention on important differences ASO loads and aggregations have for developers accustomed to BSO.
After establishing a foundation in ASO, we show you a variety of techniques to get around some of the initial limitations. Subjects include getting around the units*rates calculations, solutions for Time Balance and Time Series functionality, and possible architectural solutions that combine strengths of BSO with ASO by using Transparent Partitioning. This last subject is designed as a review of Partitioning with a focus on how to get the most out of ASO with minimal design changes.
This section focuses on the new formula calculation language MDX. We walk you through the basic syntax of working with MDX and then quickly begin to solve common formula requirements; variance analysis, relationship based ratios, working with ranges of members, cross-referencing dimensions, recursive functions, and more. This section focuses on how to convert existing calculation logic into MDX equivalent functions. We finish the class by showing you how to write custom reports to extract data using MDX.
Contact Us (Schedule Private Class or Ask Questions)