Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags powershell, AMO Rss

   Items 1 to 5 of 5   
 

Script a cube using Windows PowerShell and AMO

This installment of "Windows PowerShell and AMO" covers how to script a cube from a SQL Server Analysis Service instance to XMLA format file.  Read more...
By Additional Articles 2009/05/12 | Source: Database Journal | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 1,392 reads

Script dimensions using Windows PowerShell and AMO

Part 11 of our series on "Microsoft Windows PowerShell and SQL Server 2008 AMO" discusses how to generate a script for given dimension of the Analysis Service database to XMLA format file.  Read more...
By Additional Articles 2009/05/01 | Source: Database Journal | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 1,462 reads

Process Dimensions in an Analysis Service database

Continuing our series on our "Microsoft Windows PowerShell and SQL Server 2008 AMO," Part 8 covers how to process a dimension in an Analysis Service database using Windows PowerShell and SQL Server 2008 AMO.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 1,472 reads

Get SSAS Database Properties with PowerShell and AMO

Learn how to use Windows PowerShell and AMO to retrieve the database properties of SQL Server Analysis Service.  Read more...
By Additional Articles 2009/01/05 | Source: Database Journal | Category: amo
Rating: (not yet rated)  Rate this |   Briefcase | 1,384 reads

Discover Analysis Service's Properties using Windows PowerShell and AMO

Part 2 of this series illustrates how to use Windows PowerShell and AMO to get the various Server properties of SQL Server Analysis Service.  Read more...
By Additional Articles 2008/12/12 | Source: Database Journal | Category: amo
Rating: (not yet rated)  Rate this |   Briefcase | 1,663 reads
   Items 1 to 5 of 5   
 
Tags
analysis services (ssas) (4)    
dimensions (2)    
cube (1)    
sql server 2008 (1)    
xmla (1)