Skip to Content
User Experience Insights
Author's profile photo Ashish Farkya

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

 

Assigned Tags

      6 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Christian AH-SOON
      Christian AH-SOON

      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

      Author's profile photo Ashish Farkya
      Ashish Farkya
      Blog Post Author

      Thanks for sharing the BI 4.2 SP6  new feature.  I'm looking forward to start using SP06.

      Cheers!

      Ashish

      Author's profile photo M Mohammed
      M Mohammed

      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/

      Author's profile photo Ashish Farkya
      Ashish Farkya
      Blog Post Author

      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

      Author's profile photo KIRAN BONAM
      KIRAN BONAM

      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

      Author's profile photo Ashish Farkya
      Ashish Farkya
      Blog Post Author

      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