O'Reilly logo

Microsoft® SQL Server® 2008 Analysis Services Step by Step by Scott Cameron

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

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 ...

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