Create SQL Server Analysis Services Partitions using AMO

Posted on SQL Server Central See other posts from SQL Server Central
Published on Mon, 19 Nov 2012 07:00:00 UT Indexed on 2012/11/20 17:13 UTC
Read the original article Hit count: 242

Filed under:

When you have SSAS cubes with millions of rows of data, it is very helpful to create partitions. If you have a few cubes you could probably do this manually, but if there are many or if you want to automate this process you should look for smarter solutions such as programming the creation of partitions dynamically.

Red Gate Deployment Manager NEW! Never waste another weekend deploying
Deploy SQL Server changes and ASP .NET applications fast, frequently, and without fuss, using Deployment Manager, the new tool from Red Gate. Try it now.

© SQL Server Central or respective owner