Create Cascading Prompts in Cognos Report Studio

Cascading prompts are typically used to improve the user experience when dealing with related data items consumed by the prompt page. The cascade functionality limits the displayed prompt values based on the user’s selection within the parent prompt. This built-in functionality causes the entire prompt page to be re-submitted, resulting in a possible re-run of the supporting data queries and additional time to re-render the prompt page.

• A cascading is a prompt property that allows the user to select a single or multiple values
• The following are the properties that can be defined to create a cascading prompt

Creating Cascading Prompts in Cognos Report Studio

a) Single select, auto-submit

b) Multi-select, re-prompt button

Single select, auto submit:

• Add the following query items to the list
• Product line, product type, product name, quantity, revenue
• Define a group on product line, product type
• Define a total on quantity, revenue
• Select product line, product type, product name
• From the total menu, select Build prompt page
• Select the product name value prompt
• In the properties window, select the following properties
• Multi select – Yes
• Auto submit – No
• Cascade source – Product type
• In the product type prompt
• In the properties window, select the properties
• Multi select – No
• Auto submit – Yes
• Cascade source – Product line
• Select the product line value prompt
• In the properties window, select the properties
• Multi select – No
• Auto submit – Yes
• Cascade source – X
• Save and Run the report

CASCADING PROMPTS: SINGLE SELECT, AUTO SUBMIT

Multi select and Re prompt button:

If you want to select multi items and we don’t need a finish button we use reprompt button. It is one of the properties used in multiple value cascading prompt.

• Add the following query items to the list
• Product line, Product type, Product name, Quantity, Revenue
• Define group on product line, product type
• Define total on quantity, revenue
• Select the product line, product type, product name
• From tools menu
• Select build prompt page drop beside product line, product type prompts
• Select the prompt button in the properties window
• Change the type to re prompt
• Set the following properties
• Multi select – Yes
• Cascade source – Product type
• Select the Product type prompt
• Set the following properties
• Multi select – Yes
• Cascade source – Product line
• Select the product line prompt
• Set the following properties
• Multi select – Yes
• Save & Run the report

Frequently Asked Cognos Interview Questions & Answers

Multi Select And Reprompt Button