Hi Gurus,


I am new to Microsoft's BI products.
I have few cubes which I build using Ananlysis services accesing data
from SQL SERVER 2000 DB.
I want a procedure to automate the cube building and want to schedule
it to run everyday.


thanks in advance.


Tejoo

Create a DTS package and schedule it to be executed through SQL Server. See
How to Create an Analysis Services Processing Task in the SQL Books Online:
http://msdn.microsoft.com/library/de...tauto_5bfv.asp.

--
Jay Nathan
http://www.jaynathan.com/blog



"Tejoo" <tbambulkar (AT) ets (DOT) org> wrote