Free australian online casinos. Reposted from with the author's permission. Back in 2009 I blogged about how the use of the Now function inside calculated members prevents the results of those calculations being cached for longer than the lifetime of a query. It might be worth rereading that post before you carry on to get some background on the problem here: Today I had an interesting email from a customer (thank you, Per!) showing me something I didn't know: that using the Now function in the Where clause of a query has the same effect. Here's the repro. On the MDX Script of the Adventure Works cube, I created the following calculated measure: CREATE MEMBER CURRENTCUBE.MEASURES.TEST AS Measures.Internet Sales Amount + 1; Now consider the following query.