IIF is one of the most popular MDX functions, (this was proved by these surveys). Yet, it can cause significant performance degradation, which is often blamed on other parts of the system. Many times it is simple to rewrite the MDX expression to get rid of IIF altogether, and other times it is possible to slightly change the IIF to increase ...

Well, apparently I am one of the industry influencers ! At least this is what Kimball Group thinks, because they sent me their just published "The Microsoft Data Warehouse Toolkit: With SQL Server 2005 and the Microsoft Business Intelligence Toolset" book by Joy Mundy and Warren Thornthwaite. According to the message, they have sent it ...