This content has been marked as final. Show 6 replies
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
still need o hit refresh to get eh presetnation prompt to display the lastest values
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.
thanks but that still doesnt do it...
the default set to the follwoing...
SET VARIABLE DISABLE_CACHE_HIT=1;
SELECT xxx FROM yyyy WHERE xxxx = zzz ORDER BY CURRENT_TIMESTAMP
I cant believe this....
can you share screenshot of your code with prompt. send me it email or a web link.
Did you set loglevel 2 to see which query is hitting cache and which is not?
thanks that worked with instanceconfig.xml