Cascading Prompts

Cascading Prompts

Cascading Prompts allows a user to use values selected from one prompt to filter values in another prompt.

For example, a report contains the columns Campus and School. Create prompts for these columns, and then specify that the School prompt is a cascading prompt that uses Campus as the cascading source. When users select a Campus, they see only the Schools related to the selected Campus.