SQL Server Performance Forum – Threads Archive
process cubes and rebuild all dimensionsHi,
Can I process all the cubes and rebuild dimensions from the command line; that is by executing a command.
Thanks in advance
For which version 2000/2005? In SQL Server 2000 you can create a DTS package that will include a process cube task for your cubes then just envoke the DTS using the DTSRUN command line utility. In SQL Server 2005 you can use a script file XMLA. Here are some helpful links http://geekswithblogs.net/darrengosbell/archive/2006/04/11/xmlaProcess.aspx