Chapter 5. Building hierarchies

Hierarchies are a much more important part of a tabular model than you might think. Even though a tabular model can be built without any hierarchies, hierarchies add a lot to the usability of a model—and usability issues often determine the success or failure of a business intelligence (BI) project. The basic process of building a hierarchy was covered in Chapter 2, “Getting started with the tabular model.” This chapter looks at the process in more detail and discusses some of the more advanced aspects of creating hierarchies: when you should build them, what the benefits and disadvantages of using them are, how you can build ragged hierarchies, and how you can model parent-child relationships.

What’s new in ...

Get Tabular Modeling in Microsoft SQL Server Analysis Services, Second 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.