Chapter 5. Navigation
In this chapter, we will cover the following recipes:
- Detecting a particular member in a hierarchy
- Detecting the root member
- Detecting members on the same branch
- Finding related members in the same dimension
- Finding related members in another dimension
- Calculating various percentages
- Calculating various averages
- Calculating various ranks
Introduction
One of the advantages of multidimensional cubes is their rich metadata model backed up with a significant number of MDX functions that enable easy navigation and data retrieval from any part of the cube. We can easily navigate through levels, hierarchies, dimensions, and cubes.
The goal of this chapter is to show common tasks and techniques related to navigation and data retrieval relative ...
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.
