Report Portal

Partition Slice Impact on Query Performance - SSAS2005

I've been going through a case with MS and ths issue of setting a partition slice came up.

Based on what I read here, http://msdn2.microsoft.com/en-us/library/ms174764(SQL.90).aspx, I didn't think that the slice had any impact on MOLAP data. The article states: Data slices are applicable only to objects that use the ROLAP storage mode.

Easy enough I thought, no need to ever set a slice on MOLAP data. Well, apparently I was wrong. There are some instances which you will want to set a slice.

Below is a response I received from a support tech:

Read more...

Tags: partition, performance

 

2007-2015 VidasSoft Systems Inc.