Jim1234 (1/28/2014)
Hi Team,
We need to partition our cube dynamically based on year and period(ex 201306). So when there is a data load/update is happening in the fact only the particular partition is processed and not all.
Dynamic partition I mean, when there is a load happening for a particular Year and Period, then a partition need to created in the cube.
Please suggest. Thanks.
Regards
Jim
I have done something similar using dateadd in the partition SQL statement. I had 3 partitions, "Live" which used a date filter filtering from 1st of 3 months ago to yesterday, the "Mid Range" > 3 months < 12 months, and the "Archive" which was everything older than 12 months. There's a move around on the transition into a new month where each partition needs processing but for every other day only the live partition needs processing.
Works well and is reasonably dynamic.