How to refresh Dashboard Components Automatically

[#1]

Hi Experts,

I am BW|BPS Consultant, and i am new to BOBJ. We have a developed a dashboard by using Live Office connection, and source is Webi report.

But my dashboard is not getting updated data automatically, for this we are refreshing dashboard every day manually.

I want to do this automatically. While opening dashboard it has to show updated data.

Please suggest me how to come across with this issue. If possible please provide Navigation.

Thanks in advance

Best Wishes,

PRK

[arijit_das]

use a hidden connection refresh button to refresh the connections after components are loaded.

[Former Member]

Hi Das,

Thanks for quick reply. Can you please explain me in more detail.

Thanks in advance

Regards,

PRK

[arijit_das]

you can follow this doc :

http://www.sdn.sap.com/irj/boc/go/portal/prtroot/docs/library/uuid/90ad73b1-506c-2b10-9e9b-9fde523f0...

[Former Member]

Hi,

Check the below link Praveen.

--SumanT

[Former Member]

Hi Das/Suman

Thanks for your valuable links.

Links which you have shared is not relevant to my issue. We are using BO 4.0, Xcelsius 2011.

My Dashboard is build on Webi report by using Live Office Connection. And Webi report is created on BW-Bex Query. And my end users are viewing the Dashboard by using BI Launchpad.

When ever user opens dashboard it has to update with latest data.

Please suggest me how to update with latest data in dashboard while opening.

Regards

PRK

[Former Member]

Hi Praveen,

The logic will be the same irrelevant of the version. If i understood your question correctly, you are trying to refresh the dashboard automatically without any manual intervention after invoking the dashboard using live office connection.

Last reply in the above suggested thread, he has explained how to do that.

--SumanT

[Former Member]

Hi Praveen

You can schedule your webi report on daily basis and while adding Live office connections in Dashboard please choose refresh as 0 or getFromLatestDocumentInstance. This is with reference to qaaws built on webi report.

I think same option should be available for live office also.

Regards

Shabnam

[Former Member]

Hi Shabnam,

Thanks for your quick reply.

As of my knowledge that option is available for only QAWS. In LO there is another option called "Refresh before components are loaded". My components are not getting refreshed even though that option is enable. Please refer screen shot.

Please let me know if i am wrong.

Regads,

PRK

[Former Member]

Hi Praveen

"Refresh before components are loaded" option is also available for Qaaws this will only load data to components beforing opening dashboard. It shows what ever data is avialable in webi at that point of time.

please check under defination tab --> Input value. I think it should be avialable for LO as well.

Regards

Shabnam

[Former Member]

Can you try with query refresh button ? if your connections is listing inside the component then i think you can do this for sure.

[Former Member]

FYI....

[Former Member]

Have you checked my above screenshot.

[Former Member]

Hi Praveen

Refer to below document, it explains clearly how to enable refresh for live office automatically.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/b02e31fb-3568-2e10-e78f-92412c3c0...

Pg-11.

There are two tabs in object properties --> refresh you can modify refresh option in this tab.

Hope this solves your automatic refresh issue.

Regards

Shabnam