Sunday, September 09, 2007
I won't cover here the topic of Exception handling in MDX, but show you a funny thing that I have never seen in any computer language. Consider this MDX code:
iif (1.0e+40 * 1.0e+40 = (1/0), "Overflowed", "Didn't Overflow")*
On some processors, this code will output "Overflowed". That's because this multiplication will overflow and (1/0) also overflows, so what we have here is two "overflow values" that are equal.
Where on earth have you seen something like this???
* Taken from the book "MDX Solutions" second edition, p. 136