This content has been marked as final. Show 5 replies
Have you tried doing by selecting Prompt Columns options LIMIT VALUES BY.1 person found this helpful
Hi,1 person found this helpful
Have tried with "Auto-Complete Functionality for Prompts" feature (obiee 22.214.171.124.0)
If your in obiee10g refer
Thanks for the reply. I never used that option and using 10g. May I know how to use it if applies in 10g?
You can try "Constrain" option in 10g to limit the values of prompts, bi server will run the queries by including the values selected in the first prompt . Please note this will not populate the prompt results automatically but values will be constrained when the selection screen appears.1 person found this helpful
It seems like it will work. Will try and let u know.