Strange problem – Aggregation related?? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Strange problem – Aggregation related??

Hi,<br /><br />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=’:(‘ />]<br /><br />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????? <br /><br />Also BTW, is there any difference in SP3 and SP3a of AS?? I have SP3 installed. <br /><br />At the moment I am just shooting any idea that comes to mind.<br /><br />Will appreciate help. Am really desparate.<br /><br />Many thanks.