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

Cognos runs stored procedure twice

Started by civicman4, 22 Jul 2011 02:10:21 PM

Previous topic - Next topic
Print
Go Down Pages1
User actions

civicman4

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?
Print
Go Up Pages1
User actions
BSP Software Documentation
MetaManager Documentation and Knowledgebase
Version Control Documentation and Knowledgebase
BSP Software Resources About Us
MetaManager BSP Software Training BSP Software
Integrated Control Suite YouTube Channel Micro Strategies Inc
Security Migration IBM Cognos
Integrated Management Suite