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

Prompt values in filter not appearing in SQL

Started by kimtalley, 05 Sep 2008 02:49:25 PM

Previous topic - Next topic

kimtalley

I am trying to add a date prompt to my report and am not having much luck. The report results are correct and use the prompt value. The problem is that the report takes a very long time to run. I ran an SQL profiler trace and see that the values are not being passed to SQL Server as part of the criteria. Cognos is pulling in all 1Million rows from my table and applying the filter to the results. This is not only running with terrible response time but is putting lots of strain on my SQL Server.

Any ideas how to correct this?

Thanks,
Kim

FatCat

Same issue.

what i did is open the report in Report studio and ran the sql for the query.

I noticed the filter is only applied to the cognos sql and not the native sql.

This means Cognos is bringing in all the data locally and then running the filter.

Bit of a waste eh...

I have been reading on other boards that there appears to be no rhyme or reason to when or in what situation cognos does this.

Any others experience this or shed any light on it?

FatCat

Just read in SP3 for C8.3 there appears to be a fix for some DB.
Teradata to be specific.

I am willing to bet that something in the teradata.ini file has been update