SSAS Articles 
AMO Managing SQL Analysis Service Objects with SSIS and AMO
AMO Managing SQL Analysis Service Objects with SSIS and AMO | Managing SQL Analysis Service Objects with SSIS and AMO |
| Written by ANDREW MUYOBO | |
| Saturday, 03 May 2008 00:39 | |
|
One of the really cool things about SQL Server Analysis Services 2005 is the ability to examine and dynamically manage its objects (cubes, measure groups, dimensions etc). Using the Analysis Management Objects (AMO) model you can interact with Analysis Services objects - manage and manipulate them using simple code. I currently use this method to manage very large OLAP cubes in the organisation I work for. Combined with the functionalities provided by SQL Server Integration Services (SSIS) I have found you can be extremely creative in the way you administer your OLAP solutions. Read more... (Requires SQLServerCentral registration) |
Top Rated
- SSAS Implementation Best Practices slides in PDF format
- Handling inter-dimensional members dependency and reducing cube sparsity using reference dimensions in Analysis Services 2005
- Cube structure optimization for MDX query performance in Analysis Services 2005 SP2: Tips for Parent Child Hierarchies usage
- Handling Multiple Calendars with a M2M Scenario
- Passing MDX parameters in Reporting Services reports
- Measures and calculations in cubes without natural hierarchies
- Forget SQL Management Studio, Stick to BIDS
- Null processing of measures in SSAS2005
