SAP Knowledge Base Article - Preview

2251147 - BI4.x Bad performance in BO Client Tools when retrieving data or list of values from a HANA View with many joins


  • Performance issue in WebI, when refreshing the LOV prompt coming from HANA View with many joins 
  • BO Client Tools are refreshing the List Of Values very slowly
  • Issue is reproducible in Information Design Tool as well
  • Values are retrieved much faster when working in HANA Studio or in Analysis for OLAP



  • SAP BusinessObjects Business Intelligence 4.x
  • SAP BO reports based on universe from SAP HANA View
  • SAP HANA JDBC connection


SAP BusinessObjects Business Intelligence platform 4.1 ; SAP BusinessObjects Business Intelligence platform 4.2 ; SAP HANA 1.0, platform edition


webi, webintelligence, information design tool, universe, slow, refresh, prompt, appear, retrieve, calculation view, hana view, hana, bi, rich client, idt, slowness, bad, performance, affected, parameters, @prompt, tables , KBA , BI-RA-WBI , Web Intelligence , Problem

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.