When you use SQL Server 2005 Analysis Services (please note you need to apply SP1), you'll have to follow the procedure described in this KB to configure the "cube refresh": http://support.microsoft.com/default.aspx/kb/921116/en-us