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

Creating hierarchies


Creating hierarchies is important in both tabular and multidimensional models. Hierarchies provide a better understanding of data to business users, and help them slice and dice reports and data more easily. Hierarchies can be created from a single table or from nested tables. In multidimensional, creating hierarchies from a single table or multiple tables doesn't make a difference, and both can be done simply with drag-and-drops. But in tabular, there are some differences; examples in this section show how to create hierarchies in a tabular model.