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






Comments For This Article





download


get free sql tips
agree to terms


Learn more about SQL Server tools