User Experience Insights
Auto Refresh WebI report every N seconds
Recently I came across a requirement saying ” A WebI report needs to be projected on a big TV screen / Projector, and report should refresh automatically in every 30 seconds without manual intervention”
To address this requirement, I found one solution which is through SAP Extensions.
We can enable “SAP Extensions” for a user group so that users of that group when log on to WebI, they would see an “SAP Extensions” tab which will allow us to set the refresh frequency.
Here are the steps to do so ( I tried this on BOBJ 4.2 SP03 Patch 11) –
- Log on to CMC
- Go to User Groups; Right Click -> Customization
- Click on “Extensions” tab
- Here you would get an option to enable “SAP Extensions”
- By default, BOBJ comes with an “Extension Sample 1.0.0”
- Enable this extension by clicking the “check box” right left to “Extension Sample 1.0.0”
- Save & Close
Now when you ( if you belong to the user group for which the extensions are enabled then) log on to BI Launchpad, you would see a new side panel called “SAP Extensions”, there you can provide your refresh frequency.
You can set any frequency ( in seconds) that you want and report would pull latest data from database and show it on the screen.
** Please note with SAP BI 4.2 SP6 onwards, Auto-refresh is available out of the box for Web Intelligence Reports
Cheers!
Ashish
Hi,
In SAP BI 4.2 SP6, Auto-refresh is available out of the box in Web Intelligence Interactive Viewer (see https://blogs.sap.com/2018/06/19/sap-bi-4.2-sp6-whats-new-in-web-intelligence-and-semantic-layer/)
You can set frequency in minutes, and not in seconds.
Regards
Christian
Thanks for sharing the BI 4.2 SP6 new feature. I'm looking forward to start using SP06.
Cheers!
Ashish
This solution by Rogerio Plank has been out there for a while now.
https://blogs.sap.com/2015/01/05/how-to-set-a-webi-document-to-autorefresh-each-n-seconds/
Hi Mahboob Mohammed,
Thanks for your comments.
The solution suggested in above in this post is making use of "SAP Extensions" which doesn't require any coding, it's just needs to be setup right.
Cheers!
Ashish
Hi Ashish,
I have similar requirement to display the WebI (preferably WebI or other whichever BOBJ tool works) report at Manufacturing locations TV or standalone systems.
So since the TV or standalone systems doesn't have any WAD logins or manual open of WebI report, how can I display WebI report ? can you help me out with any procedure you which you know ? (I'm trying to publish WebI block to WebService option and not sure if it works or not).
Thank you,
Kiran
Hi Kiran,
Thanks for sharing your comments on the requirements. I am glad that your requirements are on similar lines to what I tried to share here.
I believe you are on 4.2 or lower BusinessObjects BI platform ( not on BIP 4.3, released recently). If this is true, you may try using "BI Widgets".
You may choose to follow the steps listed in a very detailed blog https://blogs.sap.com/2013/05/06/how-to-configure-and-use-sap-businessobjects-widgets/
Hope this helps!
Thanks,
Ashish