Skip to Content
0
May 30, 2008 at 03:23 PM

Partitioning: can it change dynamically?

23 Views

Hey Partitioning Experts!

I am looking if this feature is possible?

I have got a cube (new-Not yet Loaded) in which I want to define Partitioning (Can be Physical/Logical). The partitioning should be in such a way that one partition will have data for last 24 months (say) and the other will hold all data prior to that. When new month data flows in the Partitioning should also dynamically shift. I was wondering if it is possible to achive and how?

Appreciate your suggestions!

Thanks

Meyps