Setup: Cognos Server 7.4 with SSAS 2005 OLAP cube.
Issue: For some reason when you turn on suppress zeroes (rows/columns) and drill down only on the default measure of the cube, it takes a very long time. If you turn OFF the suppress zeroes then it's super fast! The SQL Profiler indicates that the former sends the query with every single measure versus the latter only pulls the desired measure.
This topic has been locked.