In Taleo OBIEE we have an option to create cascading prompt. This helps in limiting the values of the prompts based on another prompt. For example, if we select the country prompt value as “United States” then the state prompt will load only the relevant states in “United States.”

These are the steps to create a cascading prompt

  • Create a prompt in OBIEE Answers as usual.
  • In the prompt page, expand the options.
  • Enable the “Limit values by” option and select the parent prompt column in the drop down.
  • Save the changes and run the report.

Click here to read more about