SQL Server Performance Forum – Threads Archive
How to troubleshoot a possible aggregation problemHi, 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.