Cube Deployment, Processing and Admin Purchase the entire course

10 September 2015 · · 1383 views

SSAS Cube Design Series

In this 30-minute video Chris Webb discusses the operational side of cubes: deployment, processing, backup and restore, synchronization, and scripting.

Although you can deploy changes from Visual Studio to your SQL Server Analysis Services database directly by using the Deploy option, this can be dangerous: roles and partitions created outside the project could be overwritten. As a result, it is safer to use the the Deployment Wizard to handle deployments to production—it gives you a lot of control over what gets deployed from your project, and what doesn’t.

Partitioning your measure groups can improve both processing performance and query performance. Creating new partitions in a measure group is a task that is commonly automated. Probably the easiest way to do this is to create an XMLA script that creates a new partition in SQL Server Management Studio and execute this—although you can, of course, build partitions manually in Visual Studio, too. These XMLA scripts can be executed in a number of places, including from within SQL Server Integration Services.

Processing is the act of loading data from a data source, usually a relational data warehouse, into Analysis Services. Dimensions, partitions, measure groups, cubes and entire databases can be processed. A number of different types of processing are available in each case. For dimensions, you have Process Full, Process Update, Process Add, Process Clear and Process Default. For partitions, you have Process Full, Process Add, Process Data, Process Index and Process Default. Using different combinations of these types of processing can reduce your overall processing times.

Other important administrative tasks include backup and restore and synchronization, which allows you to copy data from one Analysis Services data to another. Synchronization is useful in situations where you need to process your database on a different machine to the one that your end users are querying.

Log in or purchase access 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