SQL Server Analysis Services Tabular Deployment




By:
Overview

Once the tabular data model development is complete it is deployed on the SSAS Tabular server. Deployment and processing are two regular activities of SSAS Tabular data model change management. Processing the data model reads the data from data source and updates the data in the data model as per the design. In this chapter we would look at different processing options in SSAS Tabular.

Explanation

In a SSAS Tabular data model, there are three entities which can be processed - Database, Table and Partitions.

The processing options available for a database are - Process Default, Process Full, Process Clear and Process Recalc.

The processing options available for a table are - Process Default, Process Full, Process Data, Process Clear and Process Defrag.

The processing options available for a partition are - Process Default, Process Full, Process Data, Process Clear and Process Add.

From SSDT, you can right-click in the Solution Explorer and choose how to process the solution or your can select existing connections from the Model menu and process the connection. When you process the AdventureWorks solution, by default the solution is configured with Process Default option and it processes all the tables in the solution as shown below.

SQL Server Analysis Services Data Processing
Additional Information
  • You can learn about the behavior of each processing option on each tabular data model entity from here.

Last Update: 4/18/2017




More SQL Server Solutions











Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name
*Email
Email me updates

Signup for our newsletter

I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.






download





get free sql tips

I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.



Learn more about SQL Server tools