COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Namrutha on 19 Jan 2012 05:13:44 AM

Title: Cognos 10 suppress null property Vs Detail null filters
Post by: Namrutha on 19 Jan 2012 05:13:44 AM
Hello All,

In terms of report performance,the Suppression null property works better or the Detail Null filters???

Please come up with sugesstions as soon as possible..

Thanks in advance..
Title: Re: Cognos 10 suppress null property Vs Detail null filters
Post by: charism on 28 Mar 2012 08:25:45 PM
If you are talking about the suppress null property in the Report Studio Query property pane then it is usually faster than the detail null filters. BTW, this suppress null property is only enabled for specific olap data sources in classic query mode. With DQ query mode, it's enabled for all the OLAP data sources supported by DQ.