SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by Shahfaisal Muhammed / Partitions in Analysis Services / Latest Posts

RE: Partitions in Analysis Services

JRoughgarden — Mon, 07 Jun 2010 14:47:31 GMT

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.

RE: Partitions in Analysis Services

Philippe Cand — Mon, 07 Jun 2010 12:24:06 GMT

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.

RE: Partitions in Analysis Services

twalston — Mon, 07 Jun 2010 11:12:09 GMT

Yep, appreciate the real world examples as well. I have not worked much with partitioning and found that element very helpful.

RE: Partitions in Analysis Services

SallyMKS — Sun, 06 Jun 2010 16:14:02 GMT

Good one...liked the way you presented it...Marvellous, keep up the gud work!!

Partitions in Analysis Services

Shahfaisal — Sat, 05 Jun 2010 11:28:40 GMT

Comments posted to this topic are about the item [B]Partitions in Analysis Services[/B]