Cognos Prompts

[bwilson-2]

Hi all,

In my query builder reports I have 2 criteria one for Promotion Request Lifecycle state and the other for work item role. When ran from query builder they give you a drop down list of all the roles and states to choose from. In cognos I need to have a prompt that allows me to choose which state and role to run the report against. Any ideas?

Thanks,

Brian

[avillanueva]

I have Cognos but not connected to PDMLink. I connected to another database via SQL queries. I did however document it. Here is my notes. You might have adapt it on your end:
1. If you have not already, create a prompt page. Highlight Prompt Pages from the Page Explorer and drag a page from the insertable objects to the right side.

2.Next, highlight the new page and again, from Insertable objects, drag a Value prompt to the right side into the new page.

3. A wizard will appear to guide you though the create process. Enter a parmeter name that makes sense. This name will be called for later on.

4. Uncheck "Create a parameterized filter". (Here is where you might depart from my notes since I was using an SQL query)

5. The wizard will create a default query to use to populate the drop down list.

6. From here I linked an SQL query to my Query block.

I hope this fills in the details for you.