BLOGS BY TOPIC▼
BLOGS BY AUTHOR▼
BLOGS BY YEAR▼
Processing tables involves loading data into your model, and can take a long time. This blog explains how processing works in SSAS Tabular and the different options available to you, shows how to process tables or models, and gives some ideas on how to make processing run more quickly.
- The theory of processing tables in SSAS (Tabular)
- The practice of processing in SSAS Tabular (this blog)
- Some ideas for speeding up processing
Posted by Andy Brown on 19 February 2016
You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.
The practice of processing in SSAS Tabular
The previous page shows how processing works; this page shows how to do it! You can process an individual table, all tables, or else all of the tables using a particular connection (the options are described under separate headings below).
Processing an individual table
To process a single table, select the table in design or data view and then choose this menu option:
Choose this option to process a table.
Processing all of the tables for a given connection
A typical requirement is to process all of the tables from a particular SQL Server database. To do this, first choose a connection:
Choose to look at your existing connections.
Now choose a connection, and choose to process it:
Choose to process all the tables using this connection.
Processing an entire model
If you want to load the data for an entire model:
Choose this menu option to process all of the tables in a model.
Choosing processing options for deployment
When you deploy a model SSAS will process its tables, but by default it will do so only for tables and partitions whose data has changed. To change this, first show the properties of your project:
Right-click on your project and choose to show its properties.
You can now select how SSAS will copy data when you deploy your model:
In the project's properties window, change the default processing option (if you choose Do Not Process, SSAS will copy metadata when you deploy a project but won't load any data).
"Metadata" are the definitions of your tables and relationships, specifying which tables, columns and rows are included in your model, but not including the data itself.
Processing in Management Studio
You can also choose to load data from SSMS:
Right-click on the model you've deployed to Analysis Services, and choose to process it in its entirety.
You can then choose how you're going to process it, and choose OK:
Choose how you want to process the data. Process Clear wipes out all existing data, without reloading it (essentially deleting the contents of the model).
You can also process individual tables from SSMS:
Right-click on the table you want to process, and choose the option shown.
You can now tick which tables you want to process, and choose how:
You've now got complete control of what you process, and how you do it!
That's pretty much the whole story on processing (with the possible exception of partitions, covered in a separate blog). The final thing I want to look at is some ideas for speeding up processing.