• No replies
280 Posts

Pinned topic SSAS pulls all measures when using full SUPPRESS ZEROES on Default Measure

‏2009-07-25T02:52:17Z |
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.

Any clue?