June 5, 2010 at 11:28 am
Comments posted to this topic are about the item Partitions in Analysis Services
June 6, 2010 at 4:14 pm
Good one...liked the way you presented it...Marvellous, keep up the gud work!!
June 7, 2010 at 11:12 am
Yep, appreciate the real world examples as well. I have not worked much with partitioning and found that element very helpful.
June 7, 2010 at 12:24 pm
I like the article. The explanation is clear.
One subject I would like to get more info on is the remote processing of a partition. Right now, I process the cubes on a back office server and I push the processed cubes to an user facing server.
Using the remote processing from the user facing server may be a better option? I just do not want the users to be affected by the cube processing which is resource intensive.
Another article I would like to see is how to use SSIS to manage all these dimensions and partitions processing. Do you know of an article like that?
For the little story, I maintain a tally table for my partitions so I never have to manually add a new partition for a new time window. The tally table is a lookup based on calendar, it has a key,a lower and an upper bound. The bounds values gets changed as needed. The time horizon is not expanding, in this case, it is a rolling window. For old data we use another cube.
BI Guy
June 7, 2010 at 2:47 pm
FWIW, 2005 Standard Edition (and also 2008, I believe) does permit up to three partitions. We have been using it in production for several years with no problems. However, Microsoft does not provide customer support for this practice.
November 30, 2014 at 11:59 pm
Thanks @Shahfaisal
Very crisp and clear information.
Was wondering if there is a way out for dynamic partitions. Something like a partition should automatically adopt the next year's data in a new one when it comes.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply