There are two kinds of hierarchies in SSAS Multidimensional: user hierarchies and attribute hierarchies. Each attribute creates a single-level hierarchy that can be used in the designer/browser with a combination of other attributes to create a multilevel hierarchy. A user hierarchy is a predefined multilevel hierarchy that provide easier access for the end user in the frontend. One of the most important benefits of hierarchies is the ability to drill down and drill up in many MDX client tools such as Excel and PerformancePoint.
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