Report Portal

Setting Aggregation Designs on SSAS Partitions Part Two

Earlier this year I posted a Powershell script that will set the set the aggregation designs on your cube partitions. I recently created another script that contains a "Fix" flag to set the aggregation design, so you can just run it without the flag to get the info, or set the flag and fix the aggregation designs. I also added a "process" part that will run a process index on any partition whose aggregations are not fully processed.

Read more...

Tags: amo, aggregation, script, powershell

 

2007-2015 VidasSoft Systems Inc.