Using the Deployment Wizard Get Free Access Purchase the entire course

26 February 2015 · · 2583 views

SSAS Cube Design Series

Let Chris Webb, book author and a world-renowned expert on SQL Server Analysis Services (SSAS) introduce you to the world of practical cube design with this short, 5-minute video, which demonstrates how to use the SSAS Deployment Wizard. Log-in or get a free account to watch it!

The easiest way to deploy your work to the server is to use the Deploy option in Visual Studio that comes with SQL Server Data Tools BI. However this method has a number of drawbacks when you want to make a deployment into a production environment. For example, your production database may contain partitions or roles that are not in your project, and connection strings and other configuration properties may be different too. Using the SSAS Deployment Wizard is a much safer option because it allows you to only deploy the parts of your project that you want to deploy, as well as giving you the option to create a deployment script and create a fully automated deployment process—see Chris demo this in the video.

If you would like to learn more about design, building, and the deployment of multidimensional cubes, make sure to watch the remaining videos in this series, starting with Chris’s Introduction to SSDT-BI, then follow the in-depth modules on MDX.

Log in or register for free to play the video.

  • Using the Deployment Wizard 5-min Watch with Free Subscription

  • Using SQL Server Data Tools-BI 40-min

  • Designing Dimensions 1-hour 4-min

  • Cubes, Measures and Measure Groups 1-hour 10-min

  • Cube Security 30-min

  • Cube Deployment, Processing and Admin 36-min

  • Aggregations & Cube Performance 57-min

Purchase a Full Access Subscription

Individual Subscription


Access all content on this site for 1 year.
Group Purchase

from $480/year

For small business & enterprise.
Group Purchase
  • You can also redeem a prepaid code.
  • Payments are instant and you will receive a tax invoice straight away.
  • We offer sales quotes/pro-forma invoices, and we accept purchase orders and bank transfers.
  • Your satisfaction is paramount: we offer a no-quibble refund guarantee.
  • See pricing FAQ for more detail.
In collaboration with
Project Botticelli logo Oxford Computer Training logo SQLBI logo Prodata logo