I made a report showing only one column.
It shows a different result than when I run the SQL query in a query tool
The result from the query tool is the correct one.
When I put option 'Use Local Cache' to 'No', it does show the right result.
What goes wrong here?
By default Cognos will store the output data of a report that was run in a cache. When you run the report again, Cognos will check the cache for report results and use that result. I do not know what conditions/criteria Cognos use to determine when to use cache data and when to retrieve a new set of data (same sql statement maybe... if somebody can confirm, great or you can search) .
Setting Use Local Cache = No will force Cognos to retrieve a fresh set of data everytime the report is ran.
Khayman, thank you for your quick reply.
The strange thing is that the first time I run the report it already goes wrong.
Therefore it looks like the report takes the result from a different report/query.
In the query properties "Auto Group & Summarize" is default "Yes". Perhaps chaging it to "No" helps?