Hello guys,
We added a date filter to one of our reports in order to resolved the issue of long running SQL's. That issue was resolved but, the results of the filtered report were doubled. Part of my investigation was doing a tabular view of each query of the filtered report. I compared each tabular view results of the filtered report with the results of the original report (no filter) and THEY MATCHED!. But, when I run both reports through report studio, the values of the filtered report becomes TWICE the result of the original report. I know, its weird.... So, can anyone of you guys help me out on this? Any response will be much appreciated.
Regards,
DiGzâ,,¢747
Run a compare on the 2 generated SQL definitions with - for instance - notepad ++
(http://sourceforge.net/projects/notepad-plus/)
Check for the joins executed. Did adding the filter add an additional join and cause overcounting in some way.
Did you clear all caches, restarted Cognos services to make sure this is not some sort of gizmo?
Thanks for you prompt response blom0344! Can you please guide me on how to Restart the Cognos services and clearing the caches?
Thanks,
DiGzâ,,¢747
Open Cognos configuration manager on the server and simply do a restart from menu or the configuration tree. You need to make sure this is done after proper communication to others users/developers (obviously)..