557 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owls only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
How to process tables in your model, and ideas for speeding processing up
Part two of a three-part series of blogs
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 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).
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.
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.
If you want to load the data for an entire model:
Choose this menu option to process all of the tables in a model.
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.
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.
|Parts of this blog|
25 Aytoun Street