O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Summary

This chapter discusses the OLAP approach, SSAS terms, and the tools Microsoft provides to enable OLAP cubes. It presents a mini-methodology to follow that should help you get an OLAP project off the ground and running smoothly. These efforts are typically not simple, and a well-trained data warehouse analyst, BI specialist, or data architect is usually worth his or her weight in gold because of the results (and value) that can be achieved through good OLAP cube design.

Sometimes it is difficult to engage end users and get them to use an OLAP cube successfully. Easy-to-use third-party tools can greatly help with this problem.

From an SSAS point of view, the ease of control of storage methods, dimension creation, degrees of aggregation, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required