SQL Server Home
Auto-partitions in Analysis Services
as Won't Fix
6/8/2006 9:32:23 AM
i want to automatically create partitions when new dimension members appear.
SQL Server 2005 - Developer Edition (32)
Windows 2000 (all editions)
Operating System Language
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!
better data management
to post a comment.
Please enter a comment.
on 3/29/2012 at 3:18 AM
A solution similar to the partitioning function of the Database Engine would be awesome.
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
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.
on 1/29/2008 at 9:37 AM
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.
Analysis Services Team
on 8/29/2006 at 3:47 PM
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.
to post a workaround.
Please enter a workaround.
© 2014 Microsoft