Last week I wrote about incorrect totals being returned when performing a drilldown. I believe I know what the cause of it is – aggregations.
Figure One: Grand Totals are correct – they represent the total from the fact table
Figure Two: Drill down into Country Tier. Totals have changed
Figure Three: Altered partition 3/8/07 so it contains no aggregations and fully process. Also fully process 3/12/07. 3/8/07 now returns correct totals and 3/12/07 does not (numbers have changed).
I have no idea what’s going on except something is wacked in the aggregations. This has happened in several measure groups, not just one.
Anyone know what’s going on or have experienced something similar? My end users are finding these bad numbers and it’s really causing a loss in confidence in Analysis Services.