IBM Support

How to create a Cascading Prompt in Cognos Report Studio

Troubleshooting


Problem

How to create a Cascading Prompt in IBM Cognos Report Studio

Resolving The Problem

This example will show how to create Cascading Prompt for a List report.

Steps:1. Add the following columns for the report, ProductLine, ProductType and ProductName.

2. Group the ProductLine and ProductType columns.

3. Create a new prompt page by clicking on the Prompt Pages link from Page Explorer.

4. Click on the Add.. icon and in the name section, enter Products.

5. From the Toolbox tab drag and drop a Value Prompt for the first prompt and in the "Create a new parameter" section enter "ProductLine".

6. Click Next and in the "Data Item" section select ProductLine, click Next and then click Finish.

7. Create the 2nd prompt and again drag and drop another "Value Prompt" and in the "Create a new parameter" section enter "ProductType".

8. Click Next and in the "Data Item" section select ProductType, click Next, and leave Query1 checked as the query that we want to apply the filter for.

9. Click Next and in the Cascading Source drop down box select ProductLine as the source for this prompt and then click Finish.

10. Select the first prompt and in the Properties pane under the General section change the AUto-Submit to "Yes". This will populate the second prompt so that a value can be selcted.

11. Run the report to test. From the ProductLine prompt select "Golf Equipment" and from the ProductLine prompt we select Irons and then
click Finish

[{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Install and Config","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"10.2;10.2.1;10.2.2","Edition":"All Editions","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 June 2018

UID

swg21338615