Saturday, November 17, 2007
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.