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.

Monday, November 12, 2007

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.