Auto-partitions in Analysis Services

Auto-partitions in Analysis Services by Jamie Thomson

Closed

as Won't Fix Help for as Won't Fix

Type:	Suggestion
ID:	127378
Opened:	6/8/2006 9:32:23 AM
Access Restriction:	Public

Workaround(s)

view

i want to automatically create partitions when new dimension members appear.

Details (expand)

English

SQL Server 2005 - Developer Edition (32)

Analysis Services

Windows 2000 (all editions)

US English

As suggested here: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=461211&SiteID=1
it would be nice to have "dynamic" partitions. i.e. A new member appears in a dimension and a partition is automatically created for it.

An easy explanation for this being useful is having a partition for each year in teh time dimension. Whenever a new year appears - a new partition is created.

I also think it would be nice to have a logical "grouping" of partitions within a measure group so that we could place all these auto-partitions into a group and say "Process all of those please". Hope that makes sense!

Improved Administration

Improved Security

Improved Performance

better data management

0 attachments

Posted by Zoltán Horváth on 3/29/2012 at 3:18 AM

A solution similar to the partitioning function of the Database Engine would be awesome.

Posted by Jamie Thomson on 3/24/2010 at 6:31 AM

Seeing as this has been closed without explanation I have re-submitted: https://connect.microsoft.com/SQLServer/feedback/details/544256/auto-partitions-in-analysis-services

Posted by Jamie Thomson on 1/29/2008 at 10:04 AM

OK Sherry, thanks very much. I appreciate the feedback.

I look forward to this in katmai + 1.

Posted by Microsoft on 1/29/2008 at 9:37 AM

Jamie,

Regretfully, we were not able to add this capability for the current release. We still think this is a great idea, and will revisit this during planning for the next release. Thanks again for taking the time to file this suggestion.

Sherry,
Analysis Services Team

Posted by Microsoft on 8/29/2006 at 3:47 PM

Jamie,

We think this is a good idea and we'll look into adding this capability if we can get to this area in Katmai. We're currently having to make add/cut decisions, hence the current resolution.

Regards,
Rob/Matt