SQL Server Performance Forum – Threads Archive

Strange problem – Aggregation related??

Hi, When I am at the ALL level of some of my dimensions, I do not see the measures adding up at the ALL level of other dimensions but when I select individual levels, the data shows up fine. This is strange becuase I have throughly gone through the underlying tables/views making up my fact and dimensions and the underlying data is all there [<img src=’/community/emoticons/emotion-6.gif’ alt=’

‘ />] Has anyone been through something like this? This seems like that when the cube is processed (I am doing a FULL process and I also Rebuild my dimesnions) the aggregations are somehow not being calculated properly????? Also BTW, is there any difference in SP3 and SP3a of AS?? I have SP3 installed. At the moment I am just shooting any idea that comes to mind. Will appreciate help. Am really desparate. Many thanks.

]]>