Analysis Services PowerShell Reference

SQL Server 2012 Analysis Services (SSAS) includes an Analysis Services PowerShell (SQLAS) provider and cmdlets so that you can use Windows PowerShell to navigate, administer, and query Analysis Services objects. For more information about loading and using the provider and cmdlets, see Analysis Services PowerShell.

Analysis Services Cmdlets

Analysis Services provides eleven cmdlets that correspond to methods in the Microsoft.AnalysisServices namespace. The following table describes each cmdlet and provides a link to the corresponding AMO method.

If you want to use PowerShell to perform a task that is not represented in the following list (for example to create or synchronize a database), you can write XMLA script for that action, and then execute it using the Invoke-ASCmd cmdlet.

Cmdlet	Description	Equivalent AMO Methods
Add-RoleMember cmdlet	Add a member to a database role	Add
Backup-ASDatabase cmdlet	Backup an Analysis Services database	Backup
Invoke-ASCmd cmdlet	Execute a query	Execute
Invoke-ProcessCube cmdlet	Process a cube	Process
Invoke-ProcessDimension cmdlet	Process a dimension	Process
Invoke-ProcessPartition cmdlet	Process a partition	Process
Merge-Partition cmdlet	Merge a partition	Merge
New-RestoreFolder cmdlet	Create a folder to contain a database backup.	RestoreFolder
New-RestoreLocation cmdlet	Specify one or more remote servers on which to restore the database.	RestoreLocation
Remove-RoleMember cmdlet	Remove a member from a database role.	Remove
Restore-ASDatabase cmdlet	Restore a database on a server instance.	Restore