January 28, 2014 at 10:13 am
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
January 28, 2014 at 12:43 pm
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.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply