DTS has an Analysis Services object which allows you to process dimension and cube objects. Create a package (or series of packages depending upon how sophisticated you need the process to be) and schedule it to run under SQL agent.
Scot J Reagin
sreagin@aspirity.com
Scot J Reagin
sreagin@hitachiconsulting.com