Frequently Asked Question

Symptom

• You want to auto refresh your dashboard. With this feature, for instance, you can set your report in fullscreen mode (with N4V Fullscreen component) and display it on a TV in your office.

Reason and Prerequisites

Environment:

• SAP BusinessObjects 4.2
• N4V All versions

Resolution

There is no setting in Webi to automatically refresh a report in version 4.2 (an option exists only in Webi 4.3). There is a sample of Webi extension that can be activated in 4.2 (see the How to page here : https://blogs.sap.com/2018/06/19/auto-refresh-webi-report-every-n-seconds/).

Another way is to follow the below steps.

The workflow to realise this auto validation is the following :

1. In your report, insert a blank cell with the following content :
2. This script will refresh the report each 10000 milliseconds (10sec).
3. Validate the formula and, in the Format Cell, change the Display setting to read content as "HTML" :
4. In the CMC, through Applications / Web Intelligence / Properties, enable the Javascript elements :

Now when you open your report, it will automatically refresh every 10 seconds.

Now we can enhance this feature !

By addind a N4V component, you can customize this feature to make the delay of refresh variable and set by the user.

1. Create a Webi variable called "Delay" (for instance) and set with ="0" content : 
2. Insert in your report a Simple Slider with the following input parameters (this will generate a slider from 0 to 120 with a step of 10 and send the selected value in the Delay variable) : 

3. Now update the script cell previously created to auto refresh the report with this content : 

   

4. This script will trigger the auto refresh every N seconds (content of the Delay variable) only if the Delay is >= to 10 seconds. You can update the settings (min/max/step) of the N4V slider according to the script values as you which.

5. The result should be : 

   

   and your report will automatically refresh every N seconds.