Report Portal

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



Tags: excel, management, amo, process, script


2007-2015 VidasSoft Systems Inc.