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 11 of 11   
 

Data Mining Part 29: Programming with C# and AMO

In this article, we will show some debugging tips for working with C# and the AMO code for working with Analysis Services and the Data Mining Models.  Read more...
By Daniel Calbimonte 2015/06/16 | Source: SQLServerCentral.com | Category: data mining
Rating: |  Discuss |   Briefcase | 2,118 reads

Data Mining Part 28: Programming with AMO and VB

In this article we will use VB.NET to connect to our Mining Models.  Read more...
By Daniel Calbimonte 2015/06/04 | Source: SQLServerCentral.com | Category: amo
Rating: |  Discuss |   Briefcase | 2,914 reads

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,068 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,484 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,450 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,541 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,677 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,540 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,456 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,717 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,231 reads
   Items 1 to 11 of 11   
 
Tags
analysis services (ssas) (7)    
powershell (5)    
c# (2)    
cube (2)    
data mining (2)    
dimensions (2)    
integration services (ssis) (2)    
xmla (2)    
bi (1)    
data dictionary (1)    
detach database (1)    
extended properties (1)    
partitions (1)    
sql server 2008 (1)    
vb.net (1)    
xml (1)    
xquery (1)