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

Content with tag AMO Rss

   Items 1 to 9 of 9   
 

Create SQL Server Analysis Services Partitions using AMO

When you have SSAS cubes with millions of rows of data, it is very helpful to create partitions. If you have a few cubes you could probably do this manually, but if there are many or if you want to automate this process you should look for smarter solutions such as programming the creation of partitions dynamically.   Read more...
By Additional Articles 2012/11/19 | Source: MSSQLTips.com | Category: analysis services (ssas)
Rating:  Rate this |   Briefcase | 2,003 reads

Managing Data Dictionaries in DW and DSS Database Applications

Second in the series of tools & techniques to help manage aspects Of Enterprise BI implementation.  Read more...
By Frank A. Banin 2011/12/20 | Source: SQLServerCentral.com | Category: bi
Rating: |  Discuss |   Briefcase | 5,411 reads

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,393 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,464 reads

Detach and attach Analysis Service Database using Windows PowerShell and SQL Server 2008 AMO

This installment of our series on " Microsoft Windows PowerShell and SQL Server 2008 AMO" examines the various types of Analysis service database detach and attach methods.  Read more...
Rating:  Rate this |   Briefcase | 1,605 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,473 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,385 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,664 reads

Managing SQL Analysis Service Objects with SSIS and AMO

You can manage SSAS objects using AMO and SSIS which enables you to have detailed control of SSAS Administrative tasks.  Read more...
Rating: |  Discuss |   Briefcase | 5,137 reads
   Items 1 to 9 of 9   
 
Tags
analysis services (ssas) (7)    
powershell (5)    
cube (2)    
dimensions (2)    
integration services (ssis) (2)    
xmla (2)    
bi (1)    
c# (1)    
data dictionary (1)    
detach (1)    
extended properties (1)    
partitions (1)    
sql server 2008 (1)    
xml (1)    
xquery (1)