We have a cube that was displaying revenue at the monthly level for our shops.
The aggregration was done in SQL by before being read into the fact table that the cube was based on.
I was tasked to take the aggregration down to daily level.
What has happened is that my cubed monthly totals do not work out to the 'old' monthly sales.
One store is 0.4 % different on one measure and a total figure is about £300 out on sales of £48K
I am thinking a rounding error.
I appreciate the details are important but I do not want to come on here and expect someone to look through my code. :-)
I am more after pointers on what to look for and if anyone has seen this sort of thing before.
Any input appreciated.
View Complete Post