Use Powershell to Get SSAS Partition Details
User Rating: / 1
Written by Richard Lee   
Tuesday, 29 April 2014 18:14

The Powershell script below returns information on all the partitions within the Measure Groups of a given cube. I prefer to use Powershell to get this data as there's no way to get he info out of the UI this quickly. If, like me, you have lots of partitions within a Measure Group and want to exit the script you can press "X" when the list reaches the bottom of the screen. The script will pause at the end of the screen so that you can review the partitions, and to give you the option to exit or to carry on through the partitions.




Pyramid Analytics