Processing Tabular Models

Once a Tabular Model has been loaded initially, you may need to reload the data to pick up new data or handle data source refinements. Unlike a multidimensional model, which does not need data to work, the Tabular Model starts out in a processed state.

How to do it…

The Processing primarily occurs during development, while using Microsoft SQL Server Management Studio:

  1. In order to process the database, individual tables, or partitions, you merely need to right-click on the object and select the Process option. This will open the Process dialog box.
  2. From here you will pick your processing option and click on OK to process the selected object.

How it works…

Processing the model refreshes the data or the metadata depending on the ...

Get SQL Server Analysis Services 2012 Cube Development Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.