Just a quick note on Name Calculations in SSAS, they need to be written in whatever SQL dialect the underlying DB engine (probably MS-SQL) understands. I wanted to make a Sales Margin calculation, and to avoid a Divide by Zero where sale price was zero, my code for this was:
<br /> CASE<br /> WHEN Sale<>0 THEN (Sale-Cost)/Sale<br /> ELSE 0<br /> END<br />
Never before have I needed four lines to do a simple IF. ;-)


I’m not a frequent user of CoverFlow, but now that I wanted to use it on my shared iTunes library in my living room from the Windows iTunes client I noticed that I cannot select neither CoverFlow nor in an album list. I’m stunned and looking forward to trying it out on my MBP


These instructions are a great 5 minute guide to using iTunes at work. My mini at home already has SSH access enabled, so fire up Putty, make a tunnel, install the helper app and Boom! You’ve got music at work


This is just the weirdest. Not three minutes ago my Norwegian mobile phone that I haven’t had turned on since christmas suddenly turned itself on, and just a second thereafter my smoke alarm went bananas. I can smell no smoke, no smoke outside, no smoke in the entrance, not anywhere. What’s going on? Normally I would just assume it malfunctioned, but my mobile phone turned itself on! It shouldn’t be able to do that??


Big hands

Music 2008-01-26