Chapter 8. When MDX is Not Enough
In this chapter, we will cover the following recipes:
- Using a new attribute to separate members on a level
- Using a distinct count measure to implement histograms over existing hierarchies
- Using a dummy dimension to implement histograms over nonexisting hierarchies
- Creating a physical measure as a placeholder for MDX assignments
- Using a new dimension to calculate the most frequent price
- Using a utility dimension to implement flexible display units
- Using a utility dimension to implement time-based calculations
Introduction
So far, we've been through the basics of MDX calculations. We learned a few tricks regarding time calculations, practiced making concise reports, navigated hierarchies, and analyzed data by applying typical ...
Get MDX with Microsoft SQL Server 2016 Analysis Services Cookbook - Third Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.