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.
Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide
By :
Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide
By:
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
Free Chapter
Data Warehouse Design
SQL Server Analysis Services Multidimensional Cube Development
Tabular Model Development of SQL Server Analysis Services
ETL with Integration Services
Master Data Management
Data Quality and Data Cleansing
Data Mining – Descriptive Models in SSAS
Identifying Data Patterns – Predictive Models in SSAS
Reporting Services
Dashboard Design
Power BI
Integrating Reports in Applications
Index
Customer Reviews