I'm trying to do pretty much the exact same thing.
You could create calculated members for each of the [date/time],[Measure] combinations and return them all, but I'm trying to avoid doing that.
I'll post back if I find anything.
SQL SERVER Central Forum Etiquette[/url]