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.

All Forums  SQL Server 2005 Forums  Analysis Server and Reporting Services (2005)  Positive numbers show as negative when aggregated

Author  Topic  twang80 Starting Member 1 Post Posted - 2009-08-31 : 13:29:45 Hi, I am running into a problem with Analysis Services. The aggregated sums when rolling up in the time dimension is showing negative numbers, even though they should be positive. For example: Year Quarter Month Date Impressions Clicks 2009 -711863599 13963434 Qtr 1 591758838 6085413 Qtr 2 1043631156 5345254 Qtr 3 1947713703 2532767 Jul -2049393247 679376 Aug -297860346 1853391 2009-08-01 65154908 27446 2009-08-02 70294223 23221 2009-08-03 137263721 55731 2009-08-04 175642671 54195 2009-08-05 164143793 83247 2009-08-06 172058463 93181 2009-08-07 157560317 59693 2009-08-08 135959403 60824 2009-08-09 148250237 68395 2009-08-10 179080351 70748 2009-08-11 179424825 87857 2009-08-12 171367555 99738 2009-08-13 168168276 94069 2009-08-14 154965337 75518 2009-08-15 134639647 72330 2009-08-16 145112467 73224 2009-08-17 180189335 79605 2009-08-18 172932546 73170 2009-08-19 173704339 102865 2009-08-20 172245034 87754 2009-08-21 152360668 72946 2009-08-22 127887113 63801 2009-08-23 141768106 63325 2009-08-24 176027172 67957 2009-08-25 165795877 67957 2009-08-26 175110566 74594 On the Date level, the Impressions display correctly. However, on the month level, negative numbers are displayed. This happens for some measures, while other display correctly. All have an int data type. The AggregateFunction for these measures is set to Sum. This problem shows up in some other dimensions (even dimensions with no hierarchy) as well. Has anyone run into this problem before or know of a way to resolve it? SQL Server Analysis Services 2005 sp4 Any help would be very much appreciated. Thank you, Tom