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

[RS] Problem with a cascading prompt in 8.2

Started by CArnold40, 25 May 2007 12:12:47 PM

Previous topic - Next topic

CArnold40

 ???

In COGNOS 8.1, I have a report that has 3 prompts, each cascading. IN other words:

Prompt1
Prompt2 (Cascade Source - Prompt1)
Prompt3 (Cascade source - Prompt2)

All prompts work fine in their current environment (8.1).

When I export this report from 8.1 and import it into our new COGNOS 8.2 environment:

Prompt1 works just fine (it's just a date range prompt).
Prompt2 seems to work fine.
Prompt3 just comes up blank, with nothing to select.

In both environments (8.1 & 8.2) I'm hitting the same data source.
I even tried rebuilding the 3rd prompt in the 8.2 environment and I still have the same issue.

Has anyone come across this problem before? And if so, what did you do to resolve it?

ANY help is greatly appreciated.

Chris

goose

I did a test woked fine try these steps:

1. Check that the Prompt 3 query has a filter for the parameter set to Prompt 2

2. Check that auto submit is true for prompt 2 (otherwise you must click Next for Prompt 3 to get populated)

Hope this helps, otherwise replicate using GOSL and post report spec