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

How to eliminate an automatic prompt from a package parameter

Started by sellerdl, 02 Oct 2009 12:09:45 PM

Previous topic - Next topic

sellerdl

Hi,

I'm creating a basic list in Report Studio that comes from Sungard delivered packages.  In their packages, Sungard has developed parameters, I'm thinking they thought it would be easier for us report developers in case we didn't want to have to create prompt pages, but that's not true.  However, I'm using SQL queries to get around how the package defines joins in this particular report. But since I'm using a table that is defined in the package, it's still throwing the prompt on the field I'm pulling in in my SQL query.  So, when the user enters all their selections in the prompt page I developed and then clicks 'Finish' another 'system generated' prompt appears for the field in my SQL query.  Can I eliminate this prompt just for this report?
Thanks for any help!
Dana

CognosPaul

When there is a prompt that's set on the query inside FM, the prompt has to be met. There's no way to force Cognos to ignore it. However, you can work around it by adding a prompt of your own with the same parameter name. If the prompt is required, add a default value. You can set the box type to none so the user won't see it. The problem is that, if the prompt is required, you do have to filter on something.

The best way to resolve something like this it to go to the source.

Have you asked Sungard to modify their packages to meet your specifications? Does your agreement with them prevent you from modifying the package yourself?