Analysis Services Processing Task

This task force the SSAS to process Database, Cube, Partition, Measure Group, Dimension, Mining Structure, and Mining Model through SSIS.
At first you must specify the connection which specifies the objects that must be processed in connection manager combo box.



Then you must add the objects that you want to get processed.



Next you must set their process options based on the action that you want to happen. There are some actions that are available for some objects that I listed them as follow:



When you set the process option to Process Incremental you will have to configure its settings, The settings are included of Measure Group, Partition, and Source Data that can be table or query.



You can change the processing order of this batch via Change Settings button. The Change Settings form has two tabs that are called Processing options tab and Dimension key errors tab.
You can set some general settings such as transaction type (Sequentional, or Parallel), write back table, and process related objects in the first tab.



Finally you can set the action that you want to occure when an error raised in the second tab.

Processing Analysis Services Objects through SSIS

There are two ways to process analysis services objects:

1. Force SSAS to handle the process via SSIS
   you must use the Control Flow Tasks for this kind of operations:
   
• Analysis Services Processing Task
  This task provides you the SSAS objects' options visually.
  
• Analysis Services Execute DDL Task
  you can specify a DDL script to this task to perform your Process via XML/A.


2. Process those objects through SSIS
   the best situation in which you can use these destinations is where you have non-standard sources and you need near real-time processing.
   you must use the Data Flow Destinations for this kind of operations:
• Dimension Processing Data Flow Destination
• Partition Processing Data Flow Destination

There are two other ways for handling these processes:

1. You can run your XML/A script via ASCMD.exe
   you can do this by using the Execute Process Task.
2. Handling the process with AMO.
   You must write program in .net language through Script Task.

I will describe each of these tasks separately, later.