Auto-partitioning

From everything I've read it seems as though partitions have to be set up ahead of time and to be honest - that makes perfect sense.

However, I'm interested in a scenario where a new partition is created whenever (say) a new dimension member appears. An obvious application of this is to create a new partition whenever a new year member appears in the Time dimension - thereby having a partition for each year.

Thoughts here? Would this be a useful feature? Is there something glaringly obvious I've overlooked that makes it a very bad idea?

Thanks

Jamie

I was just thinking the same thing quite recently (when I had to write a SSIS package to generate 650 partitions for a proof-of-concept cube) and I think it would be really useful. Probably quite difficult to implement though.

Something to submit to the MSDN product feedback website perhaps?

Chris

|||

Chris,

Good to know I'm not the only one thinking along these lines. I've submitted it here: https://connect.microsoft.com/feedback/ViewFeedback.aspx?FeedbackID=127378&SiteID=68 so take a look, vote, and add a comment.

[Product feedback page has changed by the way. They did that on the quiet didn't they?]

cheers

Jamie

|||

I've voted. This reminds me that I need to devote some time to seeing if I can get usage-based partitioning to work - that would be another cool thing to have in the next release...

http://spaces.msn.com/cwebbbi/Blog/cns!1pi7ETChsJ1un_2s41jm9Iyg!348.entry