Blog

  • Home
  • Cognos
  • Create Cascading Prompts in Cognos Report Studio

Create Cascading Prompts in Cognos Report Studio

  • (5.0)
  • | 2694 Ratings

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 which 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

CASCADING PROMPTS: SINGLE SELECT, AUTO SUBMIT

CASCADING PROMPTSCASCADING PROMPTS2CASCADING PROMPTS3CASCADING PROMPTS4CASCADING PROMPTS5CASCADING PROMPTS6CASCADING PROMPTS7CASCADING PROMPTS8CASCADING PROMPTS9CASCADING PROMPTS10CASCADING PROMPTS11CASCADING PROMPTS12CASCADING 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 ButtonMulti Select And Reprompt Button2Multi Select And Reprompt Button3Multi Select And Reprompt Button4Multi Select And Reprompt Button5Multi Select And Reprompt Button6Multi Select And Reprompt Button7Multi Select And Reprompt Button8

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

Subscribe For Free Demo

Free Demo for Corporate & Online Trainings.

Ravindra Savaram
About The Author

Ravindra Savaram is a Content 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.


DMCA.com Protection Status

Close
Close