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

Query about Report Studio

Started by NitinSaxena, 12 Apr 2011 08:58:47 AM

Previous topic - Next topic

NitinSaxena

I have a report (Lets say reportA) which consist of the inner join of two large tables. I joined these two tables in Framework Manager and using the querySUbject in my report.

This report is being used as a drill through report. So parameter coming from the source report will be applied as filters in reportA but the query will fetch all the data first and then it will apply the drill through filters.

I have problem that data is too large so the query is taking lots of time (2-2.5 minutes).

Any suggestion?

Regards,
Nitin