Report Portal

Processing SSAS Cubes using PowerShell

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.

Read more...

Tags: amo, process, powershell

 

2007-2015 VidasSoft Systems Inc.