:crazy: Can anyone explain the difference in MDX between using SUM versus using aggregate?
After moving a cube from one machine to another and going from service pack 1 to service pack 2 we can no longer use "aggregate" but have to use "sum". The problem is we now get different results.
If we look at the same MDX query on both machines (SPK2 and SPK1), when we change both queries to use "SUM", we get the same results - wrong ones. SPK1 still allows "AGGREGATE" and has the expected correct results.