Using Tabular Models - SQL Server Analysis Services 2012 Cube Development - page 361

3. Next, select the Steps page and click on New to create a new step. In this
step, set the following properties:

• Step Name : Process Model
• Type : SQL Server Analysis Services Query
• Run As : Choose a Run As account with permissions to the database
• Server : Server name
• Database : SSAS Cookbook Chapter 9
• Command : Use the preceding code

4. Click on OK , and this will save the step. You can then set the schedule as
needed to process the database.

There's more…

You can also follow the same steps and process individual tables and partitions. This
allows you the flexibility to only process those objects which have changes in them.

Note

My preference is to use the Full processing mode when processing SSAS ob-
jects. This requires the least amount of overall maintenance. I only move away
from this when processing times interfere with usage.

See also

• There are a couple of projects on CodePlex that describe other automation
techniques using AMO and PowerShell. Check these out if using SQL Server
Agent is not a possibility:

• Tabular Database PowerShell Cmdlets at ht-

tp://tabularcmdlets.codeplex.com/
• Tabular AMO 2012 at http://tabularamo2012.codeplex.com/