Setting data slices on MOLAP partitions
Last month I had a case open with MS and the subject of setting data slices came up. (http://jesseorosz.spaces.live.com/blog/cns!E322FD91218E57CF!304.entry). I decided to do a little investigating myself and found some of our queries were doing a scan of all the partitions when they shouldn't have been. Not good. This was severely slowing down user queries.
After running queries and setting the data slices manually it became evident this was the problem. I'll set the slices via my AMO code. Well, it wasn't as easy as I initially thought it would be. All of our measure groups set slices on dates, however the date dimensions can have different names across cubes. Revenue Date, Sales Date, Customer Date ect.
Tags: partition, performance