Community

Optimize a SQL Server Analysis Services Measure Group Partition for Performance

(Siddharth Mehta) In SQL Server Analysis Services(SSAS), each measure group by default has at least one partition. When a cube is created, this partition would not have any aggregation schemes defined, so these partitions are not optimized for performance. As you know, aggregations are pre-calculate

Read More - Register for Free Membership