Processing SSAS Cubes using PowerShell
There are 3 ways to process SSAS cubes using PowerShell:
- Import-Module "sqlps" (prompt mode) and use Invoke* commands to process SSAS cubes. This is 2012. Reincarnation of the old ASCmd.
- Load Microsoft.AnalysisServices library and use AMO to interrogate cube in full programming mode.
- Load Microsoft.AnalysisServices.XMLA and use $Server.Execute method to run an XMLA file.
Tags: amo, process, powershell