There’s been an excellent free solution for documenting SSAS metadata in multi-dimensional models for quite some time: http://www.purplefrogsystems.com/blog/2010/09/olap-cube-documentation-in-ssrs-part-1/.
I had the opportunity recently at a client to implement a version of this report solution rewritten for SSAS tabular. It took a few tweaks to the DMV queries, but I eventually got it to meet my needs. I’m sharing the source files here for those that might be in need: http://ow.ly/xYaJ3005IHu
Please try it out and let me know how it works for you.
A huge thank you to Alex Whittles for the vast bulk of this base code!
[…] Should Immediately Use It Constant and Read-Only PowerShell Variables for Admins Who Fear Change Automated Metadata Report for SSAS Tabular Yes, Foreign Keys Help Performance When to Quote in PowerShell How to Confuse the SQL Server Query […]
LikeLike
[…] SCS consultant, Jared Zagelbaum, shares from his blog a custom solution to render SQL Server Analysis Services Tabular Model metadata to users using Reporting Services; a task that is often performed manually. Read more. […]
LikeLike