stevienova.com

If you want to create a calculated measure in SSAS (SQL Server Analysis Services) that will always get the value for yesterday, this is what I have come up with:
 
CREATE MEMBER CURRENTCUBE.[MEASURES].[My Yesterday Measure] AS (StrToMember(’[Time].[Calendar Date].&['+ VBA!Format(vba!dateadd("d", -1, vba![date]()),’yyyy-MM-dd’) +’T00:00:00]’),[Measures].[My Cool Value]), FORMAT_STRING = “$#,##0.000″, VISIBLE = 1  ;
What is really cool is you can [...]

Usually, in a company, there is a “development” department and a “IT” department, and usually the departments don’t really work together. Development is focused on delivering business value through coding applications for end users or B2B clients. IT is busy making sure the corporate network is humming along, and that other internal issues related to [...]

Yeah, not good, especially if you are sunburnt (man, I think I got sun poisoning!!! - but it is finally getting better) - anyway’s it is HOT in PDX today. I guess it was 104 at 4PM, now its 4:30 and its 101. I had to go to Starbucks, since my apartment was more [...]

Yesterday I got an invite to Pownce (http://pownce.com/ScaleOvenStove/). Pownce is the next thing from Kevin Rose, the founder of Digg. It is an application that works on the web and desktop. You can send messages, links, files to your friends and to public. It is kind of like twitter but with more options, and there [...]

Since cutting cable, I have tried many different online TV programs. Democracy TV (soon to be Miro), TVTonic, Amazon Unbox, ITunes Video Store, Joost, etc. I finally got a beta invite to VeohTV the other day, and installed it Friday night. Since I am sunburned like crazy, I am holed up in my apartment anyway’s, so why not [...]

Flickr. Great online app, but uploading pictures through their website is pain at best. Other online sites have better uploading tools built right into their websites (MySpace, Facebook, etc). There is also the ability to tag your photos when you upload, but from what I have seen from all my friends photos, they aren’t tagging [...]

So, on the way to Sauvie Island, we stopped at a 7-Eleven to get a parking permit for the day, and even though the whole store wasn’t branded a Kwik-E-Mart, everything inside was “Simpsonized”, I just had to pick up a sixer of Buzz Cola. Not sure if I am going to drink it yet [...]

We went camping this 3rd, 4th, 5th of July to Silver Falls State Park, which was a nice getaway from the city, considering I live right on a busy road. There are 10 waterfalls around the trails, and we hit up 7 of them, pictures on Flickr here: http://flickr.com/photos/scaleovenstove/sets/72157600684621176/

After driving back, we went to [...]

heading out camping for the 4th/5th about an hour and half south east of Portland, will post up pics once I am back. In the meantime, if you are bored this holiday, check out http://www.geni.com - a social network for your family tree, it is very addicting, I added 70 or so relatives already, and [...]

One of my favorite things about Portland, is that the street names around where I live are named after Simpson’s characters! Matt Groening grew up in Portland, which is really cool to boot, but how cool is it to live on “Burnside” street, for Montgomery C. Burns :)
People probably think I am getting on [...]