sql server data warehouse: How can you programmatically create cube partitions? I have a cube that
is 3.2GB in fact data size and a year should contain about 35GB of fact
data. I would like to partition it into several slices, however I do not
want to create 50 partition through the GUI. Help me please. Thanks.

Kevin Brooks

If this is AS2K5, then you can use XMLA scripting. Just create one partition
using SSMS, then right-click on it and generate an XMLA script. Then you can
modify the script for the other 49 partitions and run the script through
SSMS to create them.

If using AS2K, then there is a similar, but unsupport utility called DSO/XML
that is available for download here:
http://www.microsoft.com/downloads/details.aspx?FamilyID=10744518-a2be-4534-8092-6be753fcc7bf&DisplayLang=en
--
Dave Wickert [MSFT]
dwickert@online.microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


[quoted text, click to view]