Thanks to everyone who made it to my session at SqlBits. I’m hanging around the event so feel free to ping my on twitter (@bob_duffy) if you want to chat about Cube Processing over a beet at the event. I love discussing the challenges of cube processing and swapping notes on how to optimise !! … Continue reading Optimising Cube Processing @SqlBits
Category: BI
Its no secret that optimising distinct count in SSAS/MOLAP is painful. the normal optimisation stuff is covered in various papers such as: - INI file settings to increase PageSize - Separate Measure Groups - Trying to partition by the distinct count item so that each partitions min and max values don't cross over. We recently … Continue reading Progress Report Flooding with Distinct Count MOLAP