SAP Knowledge Base Article - Public

1333166 - Xcelsius connection refresh parameters “Refresh Every” and “Refresh on Trigger” does not work correctly together in the same dashboard.

Symptom

  • Once query is refreshed on trigger cell “Refresh Every” parameter does not work correctly.
  • Query start refreshing more than once in the given time interval.
  • It happens if any query connection  is set as “Refresh on Trigger” along with any other query set as “Refresh Every”.

Reproducing the Issue

  1. Open  Xcelsius 2008.
  2. Go to Data>Connections.
  3. Add  two Query as a web service  connections.
  4. Set first query to refresh in every 30 seconds.
  5. Set the second query to refresh on trigger when cell value changes.
  6. Click Preview.
  7. Open  Fiddler or any web debugging  tool and you will observe  that first query will refresh correctly after every 30 seconds
  8. Now refresh the second query by changing the cell value.
  9. The first query will now start  to refresh twice within 30 seconds. This count will increase every time second query is triggered on cell change.
Environment: Xcelsius 2008 Service Pack 1

Cause

This behavior  has been identified as a bug and tracked under ADAPT01223477.

Resolution

Install Service Pack 2 for Xcelsius 2008. 

Keywords

Refresh, Count, Increases, Every. , KBA , BI-RA-XL , Dashboards and Presentation Design , Problem

Product

SAP BusinessObjects Xcelsius Enterprise 2008