Mindmajix

How to Create Cascading Prompts 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 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

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 SUB MIT

Screenshot_802

Screenshot_803

Screenshot_804

Screenshot_805

Screenshot_806

Screenshot_807

Screenshot_808

Screenshot_809

Screenshot_810

Screenshot_811

Screenshot_812

Screenshot_813

Screenshot_814

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

MULTI SELECT AND REPROMPT BUTTON

Screenshot_815

Screenshot_816

Screenshot_817

Screenshot_818

Screenshot_819

Screenshot_820

Screenshot_821

Screenshot_822


 

0 Responses on How to Create Cascading Prompts Cognos Report Studio"

Leave a Message

Your email address will not be published. Required fields are marked *

Copy Rights Reserved © Mindmajix.com All rights reserved. Disclaimer.
Course Adviser

Fill your details, course adviser will reach you.