COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Framework Manager => Topic started by: gutterline on 27 Oct 2009 07:55:01 AM

Title: Will Stored Procedure return random values?
Post by: gutterline on 27 Oct 2009 07:55:01 AM
We have a stored procedure that returns either 10 records or 10%, depending on which is larger.  When it is imported into FW and we run a report from it, we get the same records.

I seem to recall reading that stored procedures in FW do not 'bounce' off the database on every run, that you have to manually run the procedure from within FW to refresh the data.

Is this correct?  Is there something that I may be missing with this?

TIA,
Mark