Progress Report Flooding with Distinct Count MOLAP

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.