SQL Server Performance

Strange problem - Aggregation related??

Discussion in 'Analysis Services/Data Warehousing' started by Joozh, Mar 2, 2005.

  1. Joozh New Member

    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.

Share This Page