We have the following scenario:
1 server with MS Analisys services
1 server with MS SQL server

the analisys server has the cube storage installed locally while data is
mined from SQL Server.

i would like to schedule the cube processing.


in litterature i found that this can be done using a DTS located on the SQL
server,
but the problem is that the 'analisys services processing task' object does
not show the remote analisys server in the list of available servers.

Thanks.

i solved my problem with your suggestements


"amitj" <amitj (AT) discussions (DOT) microsoft.com> wrote

register your Analysis server in Analysis Manager. Now go to Design a DTS
package in Enterprise Manager and add a task to process cube and you should
see that ANaysis service server where you have your cubes located. Grab the
server\database\cube that you want to process automatically, save the
package and Schedule it.