January 2007 - Posts

• Performance of IIF function in MDX

  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 Read More... Posted Sunday, January 28, 2007 10:20 PM by mosha | 3 Comments Filed under: mdx, performance

• Multiselect friendly MDX for calculations looking at current coordinate

  Last year I wrote a blog about Writing multiselect friendly MDX calculations , which according to the statistics quickly became one of the most popular blog entries. In that blog we discussed how AS converts multiselect calculated members with Aggregate Read More... Posted Saturday, January 13, 2007 12:07 PM by mosha | 3 Comments