Chris Webb's BI Blog

Analysis Services, MDX, PowerPivot, DAX and anything BI-related

AS2008 Block Computation

with 2 comments

A lot has been said about block computation as it’s the biggest feature coming in AS2008. Basically it means better performing MDX, but as you’d expect it doesn’t mean that all your MDX queries and calculations are going to run faster, just some. But how do you know whether you’re going to benefit? Well, digging through the latest update of AS2008 BOL today I found the following, very detailed description of when you will benefit from these performance improvements:
 
Very interesting… the list of set functions is a bit limited (where is Filter?) but in general it looks like all common calculations are going to get faster.

Written by Chris Webb

November 21, 2007 at 6:25 pm

Posted in MDX

2 Responses

Subscribe to comments with RSS.

  1. chris,
    I am trying to use the following script as a calculated metric, and the performance works great. However, I get an issue when trying to look at the Calculated metric using other attributes from the [Health Care Profesional] dimension like sex or age.

    I got the idea from Mosha. http://sqlblog.com/blogs/mosha/archive/2007/11/22/optimizing-count-filter-expressions-in-mdx.aspx

    sum([Health Care Profesional].[Health Care Professional Key].[Health Care Professional Key],IIF([Measures].[Assignment Day]>0,1,null))

    guy

    October 9, 2013 at 4:59 pm

    • What kind of problem are you hitting? An error, incorrect results or slow performance? If it’s incorrect results, try
      sum(existing [Health Care Profesional].[Health Care Professional Key].[Health Care Professional Key].members,IIF([Measures].[Assignment Day]>0,1,null))

      Chris Webb

      October 9, 2013 at 6:04 pm


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 3,309 other followers

%d bloggers like this: