Report Portal

Calculate Size of Dimensions for a SSAS Database

I posted this Powershell script in my previous post, however I feel it's worth sharing on it's own. For full details read my previous post.

Unlike SQL Server databases, there are no DMV's or sys tables in SSAS that will provide us with size metrics. I have written about sys tables for SQL before here and here. Instead, you need to get the size of the dimension from the folder that resides within the database folder on the disk. This script will get the total size of the dimensions within an analysis services database.


Tags: amo, script, powershell


2007-2015 VidasSoft Systems Inc.