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. We recently … Continue reading Progress Report Flooding with Distinct Count MOLAP

Baselining Tabular Model Processing with a trace file

There are lots of good blogs on how to optimise the performance of a tabular model by looking at where space is going to. The alternative approach we will discuss here is to look at the trace file to determine where time has been spent on processing. This approach is very valuable for the MOLAP … Continue reading Baselining Tabular Model Processing with a trace file