Partitions in Analysis Services

  • Shahfaisal

    SSC Veteran

    Points: 223

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

  • SallyMKS

    Grasshopper

    Points: 19

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

  • twalston

    Mr or Mrs. 500

    Points: 505

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

  • jhasbufuidh

    SSC Eights!

    Points: 992

    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

  • JRoughgarden

    Ten Centuries

    Points: 1119

    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.

  • Vishal Singh

    SSCertifiable

    Points: 5830

    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.

    -Forum Etiquette: How to post Performance Problems[/url]

    -Forum Etiquette: How to post data/code to get the best help [/url]

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply