Based on an article by Benny Austin about SSIS Package to Process SSAS Cube
I have decided to process the cubes I have to maintain in the same order as suggested in his article.
- Process Dimensions
- Process default
- Process Update
- Process Facts
- Process default
- Process Partitions – default
- Process Measure groups – default
- Process Cubes – default
- Process Data
- Process Partitions – data
- Process Measure groups – data
- Process Cubes – data
- Process Index
- Process Dimensions - index
- Process Cube measures - index
- Process Partitions – index
A screenshot of what the SSIS package looks like in VS 2012:
No comments:
Post a Comment