Difference in Crosstab and list results

[gauravd20]

am getting different results between crosstab and list results.
Native sql is identical, the cognos SQL has some differences in last pass.
Am attaching the cognos sql.
please let me know wat is going wrong over here..

[gauravd20]

list cognos sql

[blom0344]

If you look closely you will notice the added 'filter' in one of the Cognos SQL's. I suspect that this is due to an additional summary filter in the report. It will not show up in the native SQL as the filter action is performed on the Cognos server (and not in the execution of SQL in the database)

We also found that there are differences between Cognos 8 versions in the generated SQL behavior. In early versions fetching a dataitem and not using it in the crosstab would still result in having it in the SQL. Later versions seem to simply remove unused items , with sometimes unwanted results.