Using Non_Empty_Behavior With YTD calculations
I always believe in giving credit where credit's due, and before I go on with this blog entry I have to declare that this isn't my idea. I heard about the general approach from Eric Jacobsen (or possibly Richard Tkachuk) at the BI Conference last year and he said it originally came from Thomas Kejser who is now on the SQLCat team; I'll be working with him on a project fairly soon so I'll ask him about it! I've not actually seen it implemented or written about anywhere though, and since I've only just got around to testing it out and seen how useful it can be I thought I'd blog about it.
Tags: mdx, non empty, performance