MS SQL Server OLAP - 2005 cube processing in SSIS

Author

2005 cube processing in SSIS

bhorwatt

2006-03-28, 8:27 pm

I am ready to start processing my UDM in batch and am trying to set up a SSIS
package using the Analysis Services Processing Task. It looks
straightforward enough. You can pick which objects you want to process, ie,
whole database, one measure group, specific partitions, specific dimensions,
etc.

My problem is only the whole database selection works for me so far. When I
choose to fully process the cube, it doesn't know to process the dimensions
also. When I try to add the dimensions, I cannot order the objects and it
puts the cube in the middle of the list. Therefore, if a dimension that
needs to be processed before the cube appears in the object list after the
cube, then the cube process fails. Deleting all objects and trying to put
them back in the right order does not work.

I tried separating the dimensions and cubes into two separate tasks, but
that did not work either. The task I had set up to process only the
dimensions also processed some of the measure groups.

This task was very simple in AS 2000 and I am wondering what I am doing
wrong here. Is there a white paper on this somewhere? I learned how to get
started with it by doing the excellent William Pearson tutorial, but this was
just processing the AS tutorial cube only. The dimensions in that cube do
not change since the data source is not updated, so not processing them did
not cause a problem.

bhorwatt

2006-03-28, 8:27 pm

Actually, clicking on the object name sorted the cube and/or partition last,
which was what I wanted. Clicking on Object type puts the partition ahead of
the dimension.

"bhorwatt" wrote:

> I am ready to start processing my UDM in batch and am trying to set up a SSIS
> package using the Analysis Services Processing Task. It looks
> straightforward enough. You can pick which objects you want to process, ie,
> whole database, one measure group, specific partitions, specific dimensions,
> etc.
>
> My problem is only the whole database selection works for me so far. When I
> choose to fully process the cube, it doesn't know to process the dimensions
> also. When I try to add the dimensions, I cannot order the objects and it
> puts the cube in the middle of the list. Therefore, if a dimension that
> needs to be processed before the cube appears in the object list after the
> cube, then the cube process fails. Deleting all objects and trying to put
> them back in the right order does not work.
>
> I tried separating the dimensions and cubes into two separate tasks, but
> that did not work either. The task I had set up to process only the
> dimensions also processed some of the measure groups.
>
> This task was very simple in AS 2000 and I am wondering what I am doing
> wrong here. Is there a white paper on this somewhere? I learned how to get
> started with it by doing the excellent William Pearson tutorial, but this was
> just processing the AS tutorial cube only. The dimensions in that cube do
> not change since the data source is not updated, so not processing them did
> not cause a problem.

Sponsored Links