Subscribe to this blog
Archives: February 2011
MDX Performance - burdens of IIF
I used to think naively that IIF is an innocent little function that can only do good and help me make a calculated measure evn faster! Wrong! Wrong! Wrong!
I found this very helpful article by Mosha Pasumansky
http://sqlblog.com/blogs/mosha/archive/2007/01/29/performance-of-iif-function-in-mdx.aspx
where he urges MDX developers to avoid using IIF function and… Read more
5 comments, 1,008 reads
Posted in aedna@SQL on 11 February 2011