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.
Additional Information
- You can learn about the behavior of each processing option on each tabular data model entity from here.
Siddharth has more than 14 years of experience in the IT Industry, with more than a decade of experience in Business Intelligence and Analytics, for clients banking, logistics, government, Media Entertainment, products, life sciences and other domains. He has been a lead architect for a portfolio of 40+ apps, containing apps in web, mobile, BI, Analytics, data warehousing, reporting, collaboration, CMS, NoSQL and other technologies. He has several certifications and is a published author for online and print-media publications, as well as the MSDN Library.
In his present role, he remains responsible for architecture design, technology stack selection, infrastructure design, 3rd party products evaluation and procurement, and performance engineering. These applications use technologies like Elasticsearch / Lucene, MongoDB, SharePoint 2013 and 2010, jQuery-based framework like Highcharts and GoJS, SQL Server and the Microsoft Business Intelligence stack (SSIS, SSAS, SSRS, MDX, PowerPivot, PowerView), jQueryMobile, Bootstrap, iOS xCode framework, and many others.
- MSSQLTips Awards: Champion (100+ tips) – 2018 | Author of the Year – 2017 | Author Contender – 2016, 2018-2019