Hi there
You can do it easily using SSIS package. Under Control flow items you can find Analysis Services Processing Task which you can use to process your dimension and cube on Analyses Services. You can execute SSIS package using Stored procedure or SQL Job Agent. In stored procedure
DECLARE @FilePath AS VARCHAR(250)
DECLARE @FileName AS VARCHAR(250)
DECLARE @Cmd AS VARCHAR(500)
Set @FilePath='D:\SSIS Packages\'
Set @FileName='ETL Process and SSAS Cube Update.dtsx'
Set @Cmd = 'DTExec /F "' + @FilePath + @Filename + '"'
Exec master..xp_cmdshell @cmd
I hope this will help
Many thanks
Qazafi