Database Reference
In-Depth Information
Automating Tabular Model processing
Power Pivot models in Excel are manually processed only, and Power Pivot models in
SharePoint can be scheduled at the data source level. Tabular Models take this one
step further by allowing you to process partitions in your model. This allows you to
use partitions to keep processing windows short and your model impact low.
Getting ready
In order to work with automation, you should have a deployed version of your Tabular
Model to work with. To see how to deploy your model, see the previous recipe on the
subject. You should also have a scheduling tool, preferably SQL Server Agent, avail-
able to create the job.
How to do it…
1. In Microsoft SQL Server Management Studio , open the tabular instance of
SQL Server Analysis Services. Right-click on the database you would like to
process, and click on the Process Database option on the shortcut menu. In
the Process Database dialog, choose the processing mode you would like to
use. (I will be using Default for the examples.) Then click on the Script button
at the top. This will open a new query window with XMLA in it.
<Process xmlns =
"http://schemas.microsoft.com/
analysisservices/2003/engine">
<Type>ProcessDefault</Type>
<Object>
<DatabaseID>SSAS Cookbook Chapter
9</DatabaseID>
</Object>
</Process>
2. Next, we need to create the job in SQL Server Agent. Open up a new job in
SQL Server Agent. Give the job a name such as Process SSAS Cookbook
Model .
Search WWH ::




Custom Search