If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Report displays incorrect results when run through Report Studio

Started by DiGzâ„¢747, 13 Jan 2009 03:57:55 AM

Previous topic - Next topic

DiGzâ„¢747

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

blom0344

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?

DiGzâ„¢747

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

blom0344

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)..