Partially Processing a Partitioned Cube

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.

4 thoughts on “Partially Processing a Partitioned Cube

  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

  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.

Leave a Reply

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

You are commenting using your 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