Trigger Cube-Processing from Excel using Cube Actions
User Rating: / 0
Written by Gerhard Brueckl   
Tuesday, 08 October 2013 22:09

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, .)





Pyramid Analytics