Download Expert Cube Development with SSAS Multidimensional Models PDF

Expert Cube Development with SSAS Multidimensional Models PDF

Expert Cube Development with SSAS Multidimensional Models



Format: PDF
402 pages
Publisher: Packt Publishing (February 24, 2014)
Language: English
ISBN-10: 1849689903
ISBN-13: 978-1849689908

The book starts off with a discussion of data warehouse design and how it relates to Analysis Services. Following on from that, best practices relating to Analysis Services cube and dimension design are covered, including topics such as optimizing dimension attribute relationships and handling fact tables that contain data at different granularities.

Next, the book looks at using MDX to implement common business calculations, and then moves on to more advanced problems like currency conversion calculations and creating a date tool dimensions.

Finally security, performance tuning, automation of administrative tasks and monitoring usage and performance each get their own chapter and subject such as dynamic security roles, using Profiler to diagnose query performance problems and automating partition creation are also dealt with.



Download Link: