COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Framework Manager => Topic started by: civicman4 on 22 Jul 2011 02:10:21 PM

Title: Cognos runs stored procedure twice
Post by: civicman4 on 22 Jul 2011 02:10:21 PM
I created a package in FM that runs a stored procedure.  I then created a report based on it in Report Studio.  When I run the report in Cognos BI, it runs the stored procedure twice.  The results I get in the report are correct, but it takes longer to get them.  I noticed this while running sp_who2 while the report was running in Cognos and it looks like the SP is getting run twice.  Is there a way to stop this from happening?