Chapter 4. Concise Reporting
In this chapter, we will cover the following recipes:
- Isolating the best N members in a set
- Isolating the worst N members in a set
- Identifying the best/worst members for each member of another hierarchy
- Displaying a few important members, with the others as a single row, and the total at the end
- Combining two hierarchies into one
- Finding the name of a child with the best/worst value
- Highlighting siblings with the best/worst values
- Implementing bubble-up exceptions
Introduction
A crucial part of report design is determining what the appropriate level of information will be presented to the business users. The appropriate level of information must be carefully matched to any business requirements, with maximized benefit to the ...
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.
