CODEWITHSUNDEEP
cognoscognos-10
Darklantern
Darklantern

Reputation: 81

Cognos 10.2 Using row values in prompt to filter another prompt

I am new to Cognos and wondering how or if possible to achieve the following.

Firstly, I have a table:

Period Id     Name  Start_Date     End_Date

1             a     01/04/2011     06/08/2013

I can create a prompt to select the Period Id from the scheme and pass it through, but I would like now to prefill a second prompt with Start_Date and End_Date of the Period Id selected in the first prompt:

Scheme Start_date <= Period.Start_Date where ID = selected Period ID from ?Period Prompt?
Scheme End_date <= Period.End_Date where ID = selected Period ID from ?Period Prompt?

I cannot use an SQL connection, so I cannot build the SQL separately eg: 

select Start, End from....Where ....= ?Prompt?

Thank you in advance....

Roger

Upvotes: 2

Views: 2669

Answers (1)

Damienknight
Damienknight

Reputation: 1896

You need to create Cascading Prompts.

Create two prompts. The first links to a parameter, lets call it Parameter1.

Your second prompt has a Cascading Source set to Parameter1. When creating the the second prompt, you have the option to create a 'Parameterized Filter'. Use that option to set what value is being filtered, and point it at parameter1.

Here is an example from IBM.

Upvotes: 1

Related Questions