On this page....


BI review & help

Want to understand what is BI & DWH? Need help with your DWH design, Analysis Services, Panorama or MDX queries? Just call me.

Call now

10$


<January 2009>
SunMonTueWedThuFriSat
28293031123
45678910
11121314151617
18192021222324
25262728293031
1234567

Aggregate Me!

RSS 2.0 | Atom 1.0 | CDF

Profile

me

Name:
   Miky Schreiber
Occupation:
   BI, Web & .Net Programmer
Location:
   Israel

more...

Sites I write in

Jewish Quote

"The most remarkable thing about my mother is that for thirty years she served the family nothing but leftovers. The original meal has never been found."
-Calvin Trillin

My Skype Status: My status

Send mail to the author(s)
Mail me

Disclaimer
The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.

 Sunday, September 09, 2007
"Exception handling" in MDX
 
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


 | 
Monday, September 10, 2007 5:54:32 AM (Jerusalem Daylight Time, UTC+03:00)
Comments [3]  |  Trackback Related posts:
Running program with the SQL Server Agent
Microsoft Chart controls affect on BI
Importing SSAS database to solution
Finding the AdomdServer assembly
The MdxInjection Program - continued
The MdxInjection Program
  #
Monday, September 10, 2007 11:44:05 AM (Jerusalem Daylight Time, UTC+03:00)
> Where on earth have you seen something like this???

In VB6
_
Monday, September 10, 2007 2:29:25 PM (Jerusalem Daylight Time, UTC+03:00)
The processing state after the initial overflow is such that the contents of the two memory addresses are probably unknown. It might be co-incidental that they are equal.

Steve | dev@null.com
Tuesday, September 11, 2007 8:14:51 PM (Jerusalem Daylight Time, UTC+03:00)
Hey,
Anonymous - Maybe you're right. The last time I coded in VB6 was six years ago.
Steve - Incidents won't happen at every trial. This "phenomenon" will happen every time, on many computers. The only thing that matters is the CPU series.
Miky Schreiber | miky@zahav.net.il
Name
E-mail
Home page

Comment (HTML not allowed)  

Enter the code shown (prevents robots):