Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Joozh
Posting Yak Master
145 Posts |
 Posted - 2005-03-04 : 01:24:44
|
| 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.Thanks & Regards.-J |
|
|
|
|
|
How to troubleshoot a possible aggregation problem