{"id":116,"date":"2008-11-09T19:10:38","date_gmt":"2008-11-10T00:10:38","guid":{"rendered":"http:\/\/www.ssas-info.com\/VidasMatelisBlog\/?p=116"},"modified":"2008-11-09T19:10:38","modified_gmt":"2008-11-10T00:10:38","slug":"powershell-scripts-to-process-dimensions-and-print-ssas-db-info","status":"publish","type":"post","link":"http:\/\/www.ssas-info.com\/VidasMatelisBlog\/116_powershell-scripts-to-process-dimensions-and-print-ssas-db-info","title":{"rendered":"Powershell scripts to process dimensions and print SSAS DB info"},"content":{"rendered":"<p>Previously, the\u00a0majority of my scripting code was done either in the\u00a0SSIS script component or in WSH. But now it is time to learn PowerShell as Microsoft included it with SQL Server 2008. I\u00a0find that\u00a0PowerShell has its own specific requirements\u00a0&#8211; like restrictive Execution Policy or the need to load a namespace definition. I have a <a href=\"http:\/\/www.ssas-info.com\/analysis-services-scripts\/1196-how-to-setup-your-computer-to-run-powershell-with-ssas\" target=\"_blank\">document<\/a> where I posted my findings and links to useful\u00a0PowerShell resources. I&#8217;ll keep updating that document as I learn PowerShell myself, so make sure you check it when you begin to use PowerShell.<!--more--><\/p>\n<p>So here are my first 3 PowerShell scripts that I added to the SSAS-Info.com <a href=\"http:\/\/www.ssas-info.com\/analysis-services-scripts\" target=\"_blank\">script library<\/a>:<\/p>\n<ul>\n<li><a href=\"http:\/\/www.ssas-info.com\/analysis-services-scripts\/1197-powershell-script-to-list-info-about-ssas-databases\" target=\"_blank\">A PowerShell script to list info about all SSAS databases<\/a>. This script goes through all databases from one specified SSAS instance and prints cube and measure group names with sizes and status. This script is very similar to the\u00a0<a href=\"http:\/\/www.ssas-info.com\/VidasMatelisBlog\/34_wsh-scripting-for-analysis-services-2005\" target=\"_blank\">previously published Windows Scripting Host script<\/a>.<\/li>\n<li><a href=\"http:\/\/www.ssas-info.com\/analysis-services-scripts\/1210-powershell-script-to-list-info-about-one-analysis-services-database\" target=\"_blank\">A PowerShell script to list info about one Analysis Services database<\/a>. This script list more detail info about one Analysis services database &#8211; list of cubes, measure groups, dimensions and optionally partitions. This script is very similar to the\u00a0<a href=\"http:\/\/www.ssas-info.com\/VidasMatelisBlog\/34_wsh-scripting-for-analysis-services-2005\" target=\"_blank\">previously published Windows Scripting Host (WSH) script<\/a>.<\/li>\n<li><a href=\"http:\/\/www.ssas-info.com\/analysis-services-scripts\/1211-powershell-script-to-process-all-dimensions-in-one-analysis-services-database\" target=\"_blank\">A PowerShell script to process all dimensions in one Analysis Services database<\/a>. You can pass parameters to specify\u00a0the process type (ex: ProcessFull, ProcessUpdate), or a parameter to specify if you want to do processing of each dimension in parallel (default) or by itself. You can also specify if you want to print the\u00a0dimension status info before and\/or after processing. This script is very similar to the\u00a0<a href=\"http:\/\/www.ssas-info.com\/VidasMatelisBlog\/8_ssis-package-to-process-all-dimensions-in-ssas-2005-db-continuing\" target=\"_blank\">previously published SSIS script<\/a>.<\/li>\n<\/ul>\n<p>Enjoy at your own risk. As always, your comments and suggestions are very welcome!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Previously, the majority of my scripting code was done either in the SSIS script component or in WSH. But now it is time to learn PowerShell as Microsoft included it with SQL Server 2008. I find that PowerShell has its own specific requirements &#8211; like restrictive Execution Policy or the need to load a namespace definition. I have a document where I posted my findings and links to useful PowerShell resources. I&#8217;ll keep updating that document as I learn PowerShell myself, so make sure you check it when you begin to use PowerShell.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[14,6],"tags":[10,22,15],"aioseo_notices":[],"_links":{"self":[{"href":"http:\/\/www.ssas-info.com\/VidasMatelisBlog\/wp-json\/wp\/v2\/posts\/116"}],"collection":[{"href":"http:\/\/www.ssas-info.com\/VidasMatelisBlog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.ssas-info.com\/VidasMatelisBlog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.ssas-info.com\/VidasMatelisBlog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.ssas-info.com\/VidasMatelisBlog\/wp-json\/wp\/v2\/comments?post=116"}],"version-history":[{"count":3,"href":"http:\/\/www.ssas-info.com\/VidasMatelisBlog\/wp-json\/wp\/v2\/posts\/116\/revisions"}],"predecessor-version":[{"id":119,"href":"http:\/\/www.ssas-info.com\/VidasMatelisBlog\/wp-json\/wp\/v2\/posts\/116\/revisions\/119"}],"wp:attachment":[{"href":"http:\/\/www.ssas-info.com\/VidasMatelisBlog\/wp-json\/wp\/v2\/media?parent=116"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.ssas-info.com\/VidasMatelisBlog\/wp-json\/wp\/v2\/categories?post=116"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.ssas-info.com\/VidasMatelisBlog\/wp-json\/wp\/v2\/tags?post=116"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}