Chris Webb's BI Blog

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

Partially Processing a Partitioned Cube

with 4 comments

Perhaps everyone else knows this already, but this tip has saved me loads of time so I thought I’d post it anyway…
 
I’m always breaking cubes, or rather making changes to them that put them in an unprocessed state (usually intentionally, but quite often by accident). If cube processing takes a long time this can be quite annoying: it’s always good to have a cube to browse so you can see the effect of any changes you’ve made. You can of course use a view to limit the number of rows in your fact tables which makes processing much faster, or switch the fact tables used in the dsv, but that’s not always practical – a lot of the time I’m working with cubes where the partitioning has been done using a query to slice the fact table and you don’t want to go changing all that SQL – and you can’t simply process a single partition in the cube. Or so I thought. I found out last week if you do a Process Structure (which takes seconds) on an unprocessed cube you can browse it but no data is there; if you subsequently do a Process Full on one of the partitions then you get a cube with only that partition’s data in it.
 
While we’re on this topic, it’s also worth mentioning that if you redesign the aggregations on your measure group/partitions, you just need to do a Process Index to make them available which is much faster than doing a Process Full.

Written by Chris Webb

October 10, 2006 at 11:09 am

Posted in Analysis Services

4 Responses

Subscribe to comments with RSS.

  1. Hi Chris,

    This is a very useful tip, however it seems to no longer work in SSAS 2012 (haven’t tried it in 2008). I made a full process of all my cube dimensions, a structure process of the cube itself, and a full process of a few select partitions. I expected the data from the processed partitions to show up, but using the SSMS cube browser, I get “No rows found” whatever I do. Even when I try to browse one of the dimensions without any measures, no rows show up.

    It seems to me that there may be some hidden state inside the cube, that tells the browser that it contains no rows, even though one or more of my partitions have been processed. What do you think?

    Best regards, Daniel

    Daniel Otykier

    August 8, 2013 at 3:27 pm

    • Disregard my previous comment. Everything works the way you described. I don’t know what I did wrong the first time.

      Best regards, Daniel

      Daniel Otykier

      August 8, 2013 at 3:36 pm

  2. I noted that in a SQL 2008 cube, even when there is one partition in each measure group processed, I am able to browse the cube. Is this expected? I always thought all partitions in all measure group had to be in processed state?

    Note: I did not do a process structure as well.

    Prakash

    September 25, 2013 at 5:34 am

    • No, not all partitions have to be processed for you to be able to browse the cube, but somewhere along the line the structure must have been processed too.

      Chris Webb

      September 25, 2013 at 9:23 am


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,083 other followers

%d bloggers like this: