O'Reilly logo

Pro SQL Server 2008 Analysis Services by Philo Janus Guy Fouché

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

Chapter 13. Administration

This chapter covers the DBA side of Analysis Services. We'll start with processing cubes, and what happens when you process an SSAS cube. We'll look at Analysis Services security, and finally end with some coverage of aspects of SSAS performance management, how to design for performance, and considerations for scalability.

DBA Tasks

After you build a cube—create the dimensions, map them to measures, create your attributes and hierarchies—none of it actually does anything until you deploy and process the cube. Deploying is effectively "saving the files to the server," but let's take an in-depth look at what happens when we process objects in an Analysis Services solution.

Processing a Cube

You can process various objects ...

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