I got a dropdown Presentation prompt based on SQL , when database changes are made on a separate dashboard -A, the presentation prompt on dashboard -B is not up to date unless the refresh icon is pressed, any solution to make the presentation prompt refresh once the page is opened and always have the latest values
Check this link
or else you may use SQL Results for the prompt and add the below code at the end of existing SQL
ORDER BY CURRENT_TIMESTAMP
If helps mark
Edited by: Srini VEERAVALLI on May 23, 2013 3:42 PM
Can you try to use default value defined by a custom sql? this will make BI server to run this default sql against DB every time the page is open and it will show you the updated value.
Mark helpful if it helps.