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:
Tags: partition, performance