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

Getting rid of prompt parameters

Started by rcaesar, 03 Feb 2010 07:42:26 PM

Previous topic - Next topic

rcaesar

Hi

Here is the scenario. - C8.4

I have developed a Prompt Page with a few prompts to run a report. That works fine.

As I have put in a lot of formatting in the prompt page, I just copied the Prompt page, and in fact deleted all the prompts, so that I can develop new prompts for a different report.

I thought if I deleted any reference to the parameters in filters, that would get rid of them, but the old parameters still keep popping up. Where else could these param references be hiding? How do I create new parameters and delete those still hanging around.

Both the reports are in the same package.

Also, is there anyway I can bring back the prompt UI when editing prompts?

I am new to 8.4, and searched for answers before posting. Appreciate any help.

paddhu

The only places where parameters are referenced can be in filters and the prompt controls. Having said that, I think your prompt controls on the copied page still have references to the old parameters. Select a prompt control, and check its Properties -> Parameter.
Hope this solves the problem.

imts

If u want to find any danglin parameter references - best way is to copy the XML and paste it to notepad and do a FIND for the parameters ...

If they are being referenced by a filter xpression u can find them in <filterExpression> (?paramXYX?) </filterExpression> kind of format.

Alternatively they can be referenced by variables too - Check there too. But searching XML is a full proof method.

-
TS

MFGF

Quote from: paddhu on 03 Feb 2010 10:51:40 PM
The only places where parameters are referenced can be in filters and the prompt controls. Having said that, I think your prompt controls on the copied page still have references to the old parameters. Select a prompt control, and check its Properties -> Parameter.
Hope this solves the problem.

Hi,

Parameters can also be used in calculations (query item expressions) and in the expressions for variables, so you need to check each of these too.  As Imts suggests, scanning the XML for the parameter can be an quick and easy method of identifying where it is used if you are having trouble finding it.

Regards,

MF.
Meep!

rcaesar

Thanks TS, MF and Paddhu. All your suggestions are really good. I think I have a handle on it now. I was barking up the wrong tree - thinking this was something to do global/local variable declarations :-)

I found out ultimately that, once I start using and saving with the rebuilt parameters, the old ones go away.

I applaud all of you guys!

paddhu

QuoteParameters can also be used in calculations (query item expressions) and in the expressions for variables, so you need to check each of these too.

Missed it. Good that it was brought out. Thanks to MF and imts.