I recently discovered that SSAS silently handles arithmetic overflow and returns garbage. For example when calculating aggregations for a 4-byte integer measure, when the sum exceeds the maximum storage it returns the overflow garbage instead of raising an error.
I can work round the problem by changing the measure storage to 8-bytes, but that doubles my storage and the number of bytes I have to read for the aggregate.
Is there a way round this problem that doesn't effect performance?
View Complete Post