Chapter 8. Deploying and Processing

We've discussed deploying and processing cubes a few times, but it's been a very rote "push this button, hope it works" process for you. In this chapter, we're going to discuss what deploying actually means and the various ways of doing it. We'll talk a bit about synchronizing databases between servers—similar to mirroring for transactional databases. Finally, we'll talk about processing the various Analysis Services objects and how to schedule processing should you need to.

Deploying a Project

After you've designed an OLAP solution, consisting of data sources, data source views, dimensions, and cubes, as well as data-mining structures, roles, and assemblies if you created them, you need to deploy the project ...

Get Pro SQL Server 2008 Analysis Services now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.