O'Reilly logo

Microsoft® SQL Server® 2012 Analysis Services: The BISM Tabular Model by Alberto Ferrari Marco Russo and Chris Webb

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 10. 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, but in this chapter, we look at the process in more detail and discuss 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.

Basic Hierarchies

First, we look at what a hierarchy ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required