Trigger Cube-Processing from Excel using Cube Actions

Recently I faced the requirement to give specific users of my Analysis Services Multidimensional cube the opportunity to process the cube whenever they want. There are several ways to achieve this:

• start a SQL Agent that processes the cube
• create some kind of WebService that does the processing
• create some custom .NET application that does the processing
• run some script (PowerShell, Command Line, ascmd.exe, .)

Read more...