- Partitions: one minute
- Dimensions: 13 minutes
- Parent Child dimension: seven minutes
- All other dimensions: six minutes
This suprised me. The PC dimension isn’t used in many aggregations and is fairly small in member number compared to the other dimensions (two of them contain more than two million members).
Next step was to manually process the dimensions via Management Studio. Did this and it became very clear at what was taking so long.
Regular dimension. Notice the non-processing of the individual partitions under TestMG01.
Parent Child dimension. Notice the processing of the individual partitions under TestMG01.
Note: The above screen shots are based off test data. The production cube has hundreds of partitions.
Updating the PC dimension required all the partitions to be reprocessed. The actual partitions weren’t being "reprocessed" per se, but rather indexes or metadata or something else was going on. I ran a trace and it wasn’t of much help.
Not wanting to make a call into PSS, I tried updating the dimension against a static dataset. This didn’t make any difference. The partitions were still reprocessing.
I finally made a call into PSS. About a day later they got back and informed me that it was a bug in Analysis Services and the call wouldn’t be decremented against our pre-purchased incidents. My reaction to the response was bittersweet. I wanted a solution, but on the other hand, knew that I had tried everything in the book to try and get it working right. It won’t be fixed in SP2 and will probably end up being a hot fix.
Now only if Microsoft could come up with a hot fix for all the hair I lost while pulling it out on this issue…