I have a DTS package that is set up to process the dimensions
contained in my cubes. They are set to rebuild the dimension
structures (and process). I have another DTS package that is set to
process the cubes, and these are set to do a full process. However, I
recently changed some of the data in one of the dimension tables, ran
the packages that are supposed to rebuild the dimension structure and
do a full process of the cubes, but I did not see the changes
reflected within that dimension in the cube. I then re-ran the
packages: same thing. So I manually rebuilt and processed the
dimensions and did a full process of the cube. I then was able to see
the changes reflected in the cube. How is this possible? The DTS
Analysis Services Processing Task does not appear to be doing what it
says it is doing. By the way, I could not determine whether it was
the dimension that was not really being rebuilt or the cube that
wasn't really being fully re-processed, b/c I have too much data in
the dimension to see all of the data in the dimension when I choose
'browse data'...the data of concern was toward that bottom of the
list, and the end of the list said something like '(more members exist
than can be displayed)'. I do know, however that that relational
dimension table did show my changes. Can anyone tell me why the DTS
packages aren't doing what they should be doing? Thanks!

Hi Sara,

I had the same effect, when I just processed all dimensions in one
'DTS Analysis Task'. Since I process every Dimension for its own
in a seperate 'DTS - Analysis Task', it works fine.

Matthias