Report Portal

Example how to generate SSAS measure group aggregations in SSIS package

Q: Need code example on how to generate Analysis Services 2005 measure group aggregations in SSIS package.

A: Link to code example:
http://www.ssas-info.com/VidasMatelisBlog/4_ssis-package-to-generate-ssas-2005-aggregates

This package will cycle through cubes, then measure groups in specified Analysis Services database. It checks if the measure group already has any aggregation design assigned to it. If yes, then the package will make sure that each partition for this measure group will use this aggregation design. If no aggregation design is found for the specific measure group, then the package creates a new aggregation design and assigns it to all partitions in this measure group. To simplify design, I will assume that just one aggregation design is important for any measure group. If a measure group has more than one aggregation design already defined, I’ll just pick one randomly and try to use it for partitions in that measure group.

 

Tags: faq, management, aggregation, ssis

 

2007-2015 VidasSoft Systems Inc.