We are creating dashbaords using Dashboards in XI 4.0 (Dashboards v6.0.4.0).
Most of our dashboards are created using query browser and published to Infoview. I believe dashboards usually time out in 20 mins(default in BO). Our goal is to have a dashboard that never times out. ie. The dashboard should remain on a screen and never require refreshing or time-out. Data should be updated automatically every 10 mins for example.
I know that queries in the Query Browser can be scheduled, but if I schedule a query to refresh every 10 mins, does that mean that the dashbaord wont time out?
We are open to publishing the dashboard outside infoview also if that helps.
Any advice/input will be appreciated. This is a very interesting challenge.
You dont schedule dashboards, or their queries. You schedule the Data via the datasource/database. Dashboards dont hold live data…ever. They fill on Open and dump on Close.
To avoid timeouts, then remove the timeout from BO. Or, Avoid a BOBJ session token by not using BOBJ. To avoid getting a token at all, then host the SWF on a webserver (not BOBJ) and dont use any BOBJ datasource (BI service). Use XML or another direct connector.
I have a dashboard that I exported as a .swf and opened it in IE 8, it has been running for about an hour and half without an issue, it refreshes about every 15 seconds. It is using a Live Office connection.
With the new Query Browser in Dashbaords 4.0, you can actually schedule the queries and indirectly schedule the dashboards. Each query has a section in the usage options where you can define how often you want that query to refresh and feed the dashboard.
Unfortunately, and much in agreement with your second point, the query browser works by opening a BO session and unfortunately expires after the defined timeout interval. Then it asks you to log in again before it starts firing the queries again.
Your point to use external connector like a web service or XML is valid, however, our first preference would be to host within Infoview since the security has been set up already and we can leverage that. If we host externally, we cant control that as easily.
The ideal solution would be to remove time-outs. Can you please elaborate on how to do that? I thought it was only possible to increase it not eliminate it. I would appreciate some insight on that.
That is really good to know that your Live office connection stays live.
Whats funny is that I thought the query browser would do the same thing, since they work in a similar fashion I believe. But even when I export my dashbaord built using query browser outside BO, it still times out after the time out interval unfortunately. I wonder why its any different.
Hi,
I am not quite sure I understand what you mean.
His article says -
"Refresh Every N Time
This option is helpful in getting the latest result-set when the dashboard is operational for long time. In this the dashboard reflects changes in every n time, we choose, according to the change of query result set."
That is exactly what I need. Maybe I used wrong language and misled you into thinking that I want to schedule/distribute the dashboard. I apologize if I did.
My only challenge is with the time out really. If I can publish the dashbaord to infoview or any other portal, like Share Point even, and eliminate timeout, that would be the ideal solution. I see that in the article you are referring to, you can increase it. However, I want to eliminate it completely. I want the Dashboad to be up on one of the monitors of the CEO indefinitely. I dont want him to have to refresh or log back in after a timeout error. I want it to be a perpetual dashboard which updates when the data changes and never times out. I hope I am conveying the right requirement.
We’ve got xcelsius hosting a keypad login routine on a touch-screen computer - it sends the user’s id and a system time to a database. It’s compiled as html and runs on a webserver completely outside of Bobj and Infoview. We had timeout errors too (not sure why) but fixed by running a quick script in the background that returns a string every five minutes.
^^ We use a similar system with a webserver (microsoft based). The SWF is hosted in Infoview. A small webpage was built that summons the SWF when the page opens. The SWF loads via HTML. To avoid timeouts, there is a script inside the html that disconnects the BOBJ session and then reconnects every 5 minutes. This method is dependant on ActiveDirectory existing and BOBJ using AD authentication.
As far as disconnecting the timeout permanently, I would take that question to the Administrators forum. Otherwise, why not set a high value in the disconnect parameter?
We have a dashboard on sharepoint which refreshes every 5 mins… We have a query in QAAWS which gets the server date and time and get refreshed every 5 mins… Then we use this date and time to refresh the queries on Dashboard on change of the data received.
(BOB member since 2007-11-05)
(BOB member since 2007-11-05)
(BOB member since 2005-03-01)