How to troubleshoot a possible aggregation problem | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

How to troubleshoot a possible aggregation problem

Hi, When I select a combination of dimensions (e.g. Month level of Time dimension, and some other dimensions) I do not see any summation of my Measure at the ALL level. The funny part is that at the same level some other measures do show correct summation i.e. the measure Total Sales shows zero but the measure TotalUnits sold shows the correct results. I am really confused and haveno clue where to start. Is there any possibility that the cube is not correctly aggregating the data?? If so, how canthis be fixed. Will appreciate any help, any clues at all.
]]>