Report Portal

Use Powershell to Get SSAS Partition Details

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.

Read more...

Tags: partition, amo, script, powershell

 

2007-2015 VidasSoft Systems Inc.