SQL Server Performance Forum – Threads Archive

process cubes and rebuild all dimensions

Hi,
Can I process all the cubes and rebuild dimensions from the command line; that is by executing a command.
Thanks in advance
Raj

---

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
http://msdn2.microsoft.com/en-US/library/ms187199(SQL.90).aspx Raulie

---

]]>