Book Image

Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide

By : Abolfazl Radgoudarzi, Reza Rad
Book Image

Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide

By: Abolfazl Radgoudarzi, Reza Rad

Overview of this book

Table of Contents (19 chapters)
Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

Working with hierarchies


Hierarchies play an important role in information management systems. Hierarchies in MDS provide an easier frontend view for end users, who can then apply changes in hierarchies much more easily.

Hierarchies in MDS come in different types: explicit and derived hierarchies. Explicit hierarchies are kind of ragged hierarchies that are created from a single entity. Derived hierarchies are created from multiple entities based on the relationship between the entities. Explicit hierarchies can be ragged, but derived hierarchies always contain a static number of levels. The following screenshot illustrates examples of derived and explicit hierarchies: