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