I'm using OBIEE 220.127.116.11.0. I have an analysis shown in my dashboard (I'm not showing the Refresh link for this analysis in the dashboard). The database is automatically loaded every 5 minutes and BI Server cache is disabled. Therefore, I need to automatically refresh the analysis (not the dashboard) every 5 minutes, so that the analysis can show the latest data.
Thanks a lot!
Hi sayak, thanks for your reply. However, your solution won't work in my case, because your script will refresh the whole page (dashboard).
What I need is to only refresh an analysis on the dashboard. Cause there will be other analysis and dashboard prompts in that dashboard which I don't want to get refreshed every 5 minutes.
Does anyone have other suggestions for this? Thanks a lot!
I dont think you can do that refreshing only one analysis.
Try to put the below code in Narrative view and add it to the analysis.
Let me/us know updates.
Edited by: Veeravalli on Nov 21, 2012 5:43 AM
Hi Veeravalli, based on you suggestion, when the 5 minutes is up, the browser (I'm using Firefox) will pop up a notification window saying: "To display this page, Firefox must send information that will repeat any action (such as a search or order confirmation) that was performed earlier." with "Resend" and "Cancel" button available. If I click Resend, it will refresh the whole dashboard. If I click Cancel, the dashboard will never be refreshed when the next 5 minutes is up (until I navigate away to other dashboard and return to this dashboard).
Any other suggestion, anyone? Thanks so much!
Hi Veeravalli, thanks for the suggestion. The code works if I'm inside the analysis editor (Answers). But when I'm in the dashboard prompt, the code doesn't do anything.
I check using FireBug that the Refresh link code (if I show the Refresh link of this analysis in the dashboard) is:
I tried using this code below in my dashboard, but it didn't work:
Any suggestions, anyone? Thanks so much!
P.S.: all [ ] in the code above are replaced with less than and greater than symbols
First 2 times I see its working.. after that not able to notice ;)
If helps pls mark :)
At last working code :)
The below code use in Text object by selecting code for HTML, when you are using it pls uncomment or take out // to see results. To test this I've tried using time for each 5 seconds interval.
Session log may not be valid case if you enable cache..
<p>A script on this page starts this clock:</p>
var d=new Date();
Hi Veeravalli, your solution works perfectly! Thanks so much for this.
I just need one small help from you. When I show the dashboard the first time, the last refreshed Time is not shown. Only after first auto-refresh is the last refresh time shown.
Could you please advise on how to make the time available even for the first time? Thanks in advance!
Hi Veeravalli ,
If I place my analysis location like this :
setTimeout("HereLink('*/Shared Folders/Inteliplan dashboards/Dashboard contents/PnL dashboard contents/by Product* ','Refresh');",5000);
I tried like this .... it didn't gave any error ... but i am not sure wether its refreshing the analysis (which is on the mentioned dashboard path ) .