Home  >  Blog  >   IBM Cognos

Create Cascading Prompts in Cognos Report Studio

With related data elements ingested by the prompt page, cascading prompts are commonly utilized to enhance the user experience. Using the cascade function, the displayed prompt values are limited to the user's choices in the parent prompt. In this tutorial, you will learn how to use Cognos Report Studio to create cascading prompts.

Rating: 5
  
 
6174

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
Learn how to use Cognos, from beginner basics to advanced techniques. Enroll for Free Cognos Certification Training Demo!

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

MindMajix Youtube Channel

CASCADING PROMPTS: SINGLE SELECT, AUTO SUBMIT

CASCADING PROMPTS
CASCADING PROMPTS2
CASCADING PROMPTS3
CASCADING PROMPTS4
CASCADING PROMPTS5
CASCADING PROMPTS6
CASCADING PROMPTS7
CASCADING PROMPTS8
CASCADING PROMPTS9
CASCADING PROMPTS10
CASCADING PROMPTS11
CASCADING PROMPTS12
CASCADING PROMPTS13

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

Multi Select And Reprompt Button
Multi Select And Reprompt Button2
Multi Select And Reprompt Button3
Multi Select And Reprompt Button4
Multi Select And Reprompt Button5
Multi Select And Reprompt Button6
Multi Select And Reprompt Button7
Multi Select And Reprompt Button8

Explore Cognos Sample Resumes! Download & Edit, Get Noticed by Top Employers!Download Now!

 

Join our newsletter
inbox

Stay updated with our newsletter, packed with Tutorials, Interview Questions, How-to's, Tips & Tricks, Latest Trends & Updates, and more ➤ Straight to your inbox!

Course Schedule
NameDates
IBM Cognos TrainingMar 02 to Mar 17View Details
IBM Cognos TrainingMar 05 to Mar 20View Details
IBM Cognos TrainingMar 09 to Mar 24View Details
IBM Cognos TrainingMar 12 to Mar 27View Details
Last updated: 04 Apr 2023
About Author

Ravindra Savaram is a Technical Lead at Mindmajix.com. His passion lies in writing articles on the most popular IT platforms including Machine learning, DevOps, Data Science, Artificial Intelligence, RPA, Deep Learning, and so on. You can stay up to date on all these technologies by following him on LinkedIn and Twitter.

read more
Recommended Courses

1 / 15