Partitions in Analysis Services

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Shahfaisal Muhammed... » Partitions in Analysis Services

Partitions in Analysis Services

Rate Topic

Display Mode

Topic Options

Author

Message

Shahfaisal

Posted Saturday, June 05, 2010 11:28 AM

Forum Newbie

Group: General Forum Members
Last Login: Yesterday @ 9:15 AM
Points: 7, Visits: 710

Comments posted to this topic are about the item Partitions in Analysis Services

Post #933163

SallyMKS

Posted Sunday, June 06, 2010 4:14 PM

Forum Newbie

Group: General Forum Members
Last Login: Sunday, June 06, 2010 4:05 PM
Points: 1, Visits: 2

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

Post #933288

twalston

Posted Monday, June 07, 2010 11:12 AM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, September 26, 2012 3:42 AM
Points: 45, Visits: 180

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

Post #933608

Philippe Cand

Posted Monday, June 07, 2010 12:24 PM

SSC Rookie

Group: General Forum Members
Last Login: Monday, April 29, 2013 10:28 AM
Points: 46, Visits: 262

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

Post #933643

JRoughgarden

Posted Monday, June 07, 2010 2:47 PM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, January 29, 2013 6:07 PM
Points: 36, Visits: 167

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.

Post #933692

« Prev Topic | Next Topic »

Permissions