SSAS Articles 
Performance Tuning Partition Slice Impact on Query Performance - SSAS2005
Performance Tuning Partition Slice Impact on Query Performance - SSAS2005
| Partition Slice Impact on Query Performance - SSAS2005 |
| Written by Jesse Orosz |
| Thursday, 06 September 2007 10:52 |
|
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: |
Top Rated
- SSAS Implementation Best Practices slides in PDF format
- SSRS Report Against a SSAS Parent Hierarchy
- Using AS Data Mining to Add Forecast Values to a Cube
- Handling inter-dimensional members dependency and reducing cube sparsity using reference dimensions in Analysis Services 2005
- Cube structure optimization for MDX query performance in Analysis Services 2005 SP2: Tips for Parent Child Hierarchies usage
- Handling Multiple Calendars with a M2M Scenario
- Passing MDX parameters in Reporting Services reports
- Using UserName to Control Data Access and Default Member in SSAS 2K5 (Carrie Williams)
