Processing SSAS Cubes using PowerShell
User Rating: / 0
Written by Vincent Rainardi   
Monday, 28 October 2013 18:28

There are 3 ways to process SSAS cubes using PowerShell:

  1. Import-Module "sqlps" (prompt mode) and use Invoke* commands to process SSAS cubes. This is 2012. Reincarnation of the old ASCmd.
  2. Load Microsoft.AnalysisServices library and use AMO to interrogate cube in full programming mode.
  3. Load Microsoft.AnalysisServices.XMLA and use $Server.Execute method to run an XMLA file.




XL Cubed