Project Description
A PowerShell provider for SQL Server Analysis Services. It implements all the interfaces required to enable you to navigate an SSAS server like a drive.

Currently the provider is a fairly thin wrapper over the AMO object model. The aim is to extend the object model to make easy to work with SSAS from the command line and to also add a number of useful cmdlets to make certain tasks easier.

Introduction to PowerSSAS
PowerSSAS release announcement - this is currently the best overview of what powerSSAS has to offer.

Installation Instructions
The current version comes with a full installer, once it is installed you just need to add the snapin to your session and you are off. The following example will load the provider and create a drive in powershell called "ssas:" that is connect to the default Analysis Services instance on the localhost.

PS > add-pssnapin powerSSAS
PS > new-psdrive ssas powerSSAS localhost 

You can then type "ssas:" to navigate to the drive and start using "dir" and "cd" to naviagate around like you would on a file system.

CmdLets

• clear-ASSession
• get-ASSession
• get-ASConnection
• send-XmlaDiscover

Example Scripts

• Getting a list of active sessions

PS > get-ASsession localhost 

• Getting a list of active connections

PS > get-ASconnection localhost 

more Example Scripts