Deployment Mechanics

When you deploy an Analysis Services database, three basic steps happen before queries can be run: build, deploy, and process.

In the build step, all the source files that make up the Analysis Services database are combined into an XML file. The source files are the .ds, .dsv, .dim, .cube, .partition, and other files found in a BIDS Analysis Services project. Each file is an XML representation of an Analysis Services object. When you build an Analysis Services project, a single .asdatabase file is created to represent these files.

In the deploy step, the .asdatabase file is wrapped in an XMLA command. The XMLA command tells the Analysis Services Server what to do with the database definition. When the XMLA command is executed ...

Get Microsoft® SQL Server® 2008 Analysis Services Step by Step 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.