Live Office & WebI Auto Refresh Query

[Former Member]

Hi

I've built a dashboard which uses Live Office connections to read WebI documents stored on a Edge XI 3.0 server. I have configured the connections to refresh when loading and every 15 minutes.

Upon loading I get asked to authenticate to the server and the dashboard updates, however, every 15minutes following although the mouse icon changes to an hour glass the data does not change.

I don't get any error messages and if I close the dashboard and open it again it updates. The dashboard was written using Xcelsius Enterprise 2008 and is exported as a .swf and opened using Internet Explorer.

Any help would be appreciated.

Rob

[Former Member · Accepted solution]

If the WebI document isn't being refreshed then the data will be the same, is the WebI doc Scheduled? Are you pointing the LiveOffice at the original WebI Doc or the Latest Instance?

[Former Member · Accepted solution]

Hi

I have the Live Office connections pointing to 'on demand' so thought that the webi would go back to the database everytime. Once I know that the data has changed but the dashboard has not updated I close the dahsboard and reopen and then it updates on load.

[Former Member · Accepted solution]

Hi Robert

Instead of using the connection Refresh on Load, use a connection refresh component, attach the LiveOffice connection. and set that to refresh on load.

[Former Member · Accepted solution]

Hi Charles

Thanks for your help.

Just found that, what I'm really after is getting it to refresh every 15mins as I display this dashboard on a large screen in our office. It works fine using Xcelsius Workgroup 4.5 and setting the parameters of the Live Office connection button, is there a similar way in 2008?

Thanks

Rob

[Former Member · Accepted solution]

The Reporting Services Button has the ability to refresh every x minutes, I've not had any reason to use this button as yet so can't offer advice on how to link it to your report.

Hope this helps

Regards

Charles

[Former Member · Accepted solution]

Hi Robert,

Can you confirm - the connection refresh button refreshes when you press it, but the refresh every 15 minutes does not?

Regards

Alan

[Former Member · Accepted solution]

Hi Alan

Actually, no. I've just done some testing and it would seem that either whether I use refresh on load or by the button, the first time I refresh and get asked for my authentication details it works but following instances do not, but I don't get any error messages. It also seems to be the same whether I use Live Office to connect to a Webi or a Crystal Reports. So I presume it somehow relates to the authenication or something similar?

Many thanks for your help

Rob

[Former Member · Accepted solution]

Hi Rob,

Have you checked a shorter interval for instance 1 minute. Perhaps your session is timing out

Regards

Alan

[Former Member · Accepted solution]

Hi Alan

I changed them to every 15 secs and stil the same.

It appears that whether I use the button or refresh on load it only refreshes the first time, and all subsequent refreshes don't return updated data.

Rob

[Former Member]

Hi Rob,

I had the same exact issue although I was on XI 3.0, not Edge 3.0. The issue was resolved after I upgraded to Fix Pack 3. I would recommend upgrading to the most recent Fix Pack available for Edge 3.0 if you have not done so already.

--Antonio