Analysis Services PowerShell Reference

SQL Server 2014 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