Microsoft SQL Server 2008 Analysis Services: Step by Step

by Scott Cameron

This hands-on, step-by-step guide helps build business intelligence solutions for the enterprise. It teaches how to create a simple multidimensional OLAP cube and progressively add features to help improve, secure, deploy, and maintain an Analysis Services database. It also explores core Analysis Services 2008 features and capabilities, including dimension, cube, and aggregation design wizards; a new attribute relationship designer; designer AMO warnings; and using dynamic management views to monitor resources. And as readers complete each lesson, they can hone their skills using the practice exercises from the companion CD. Plus, code samples illustrating the author's own, professional techniques can be reviewed and downloaded?direct from the companion Web site.

440 pages, Paperback

First published April 8, 2009

Reviews

[Cait · Rating 2 out of 5]

This book drove me nuts. What I wanted was a technically-minded overview of SSAS; what I got was a mash-up of management-level metaphors and step-by-step walkthroughs of the IDE for building cubes.

...Which, to be fair, is probably what I should have expected, at least in the second part. It may be that this is a perfectly enlightening book for people who aren't already DBAs. (I'll keep it around in case it comes in handy as a tutorial someday.) For others out there who are DBAs, at the moment I'd recommend the book I picked up when I gave up on this one -- it's twice as long but more than twice as engaging, and unlike this "Step by Step" book is written so that familiar sections can be easily skimmed.