SQL Server Performance

How to troubleshoot a possible aggregation problem

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

  1. Joozh New Member

    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.

Share This Page