Report Portal

Turn On Lazy Aggregations Through PowerShell

Not long ago we were experiencing growing pains with our cubes: We have over 20 SSAS databases with 3 MOLAP cubes on each database, and we had aggregations applied to one of the 3 cubes. To quote Jen Stirrup, aggregations are a "data structure that contains a pre-calculated summary of data. The aggregation size is smaller than the fact data it is based on, so it is expected that this will be quicker to query. Thus, aggregation design is an important method of optimising performance." (1)

Read more...

Tags: amo, script, powershell

 

2007-2015 VidasSoft Systems Inc.