Process Tabular Model Partitions
Collapse the table of content
Expand the table of content

Process Tabular Model Partitions (SSAS Tabular)

 

Applies To: SQL Server 2016

Partitions divide a table into logical parts. Each partition can then be processed (Refreshed) independent of other partitions. The tasks in this topic describe how to process partitions in a model database by using the Process Partitions dialog box in SQL Server Management Studio.

To process a partition

  1. In SQL Server Management Studio, right-click on the table that has the partitions you want to process, and then click Partitions.

  2. In the Partitions dialog box, in Partitions, click on the Process button.

  3. In the Process Parition(s) dialog box, in the Mode listbox, select one of the following process modes:

    ModeDescription
    Process DefaultDetects the process state of a partition object, and performs processing necessary to deliver unprocessed or partially processed partition objects to a fully processed state. Data for empty tables and partitions is loaded; hierarchies, calculated columns, and relationships are built or rebuilt.
    Process FullProcesses a partition object and all the objects that it contains. When Process Full is run for an object that has already been processed, Analysis Services drops all data in the object, and then processes the object. This kind of processing is required when a structural change has been made to an object.
    Process DataLoad data into a partition or a table without rebuilding hierarchies or relationships or recalculating calculated columns and measures.
    Process ClearRemoves all data from a partition.
    Process AddIncrementally update partition with new data.
  4. In the Process checkbox column, select the partitions you want to process with the selected mode, and then click Ok.

Tabular Model Partitions (SSAS Tabular)
Create and Manage Tabular Model Partitions (SSAS Tabular)

Community Additions

ADD
Show:
© 2016 Microsoft