SAP Knowledge Base Article - Preview

1476311 - Live Office refresh causes unnecessary data provider loading by the Web Intelligence Processing server

Symptom

  • Excel sheets based on Web Intelligence instances via Live Office cause the WebI Processing Server to load the data provider when refreshed
  • WebI is loading and doing security checks on the Universe, Universe connection and Universe objects
  • Xcelcius dashboards based on these XLS documents set to refresh on open cause load on the WebI Processing Server as it loads the data providers
  • The data providers should not be loaded since the Excel sheet is set to refresh against the WebI instance and not refreshing the query
  • Logs indicate the query is not being run, confirming it is unnecessary for WebI to load the data providers
  • Data providers are not loaded when viewing a successful instance of a WebI Report, similar behavior should occur when refreshing a Live Office document based on an instance


Read more...

Environment

  • BusinessObjects Enterprise XI 3
  • Web Intelligence
  • Live Office
  • Xcelcius

Product

SAP BusinessObjects Enterprise XI 3.0

Keywords

WebI, WebIntelligence, Web Intelligence, LO, Live Office, Excel, XLS, refresh, load, MS, microsoft, unnecessary, not necessary, too many, more than once, performance, data providers, data source, database, instance, schedule, successful, dashboard, refresh on open, Xcelcius, document, report, errors, under, ADAPT01307554, ADAPT1307554, ADAPT, 01307554, 1307554 , KBA , BI-RA-WBI , Web Intelligence , Bug Filed

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.