SAP Knowledge Base Article - Public

2115831 - BI4: performance issue when loading a dashboard containing several Query prompt selectors


  • The dashboard is taking time to initialize/open when it contains several Query prompt selectors


  • SAP Dashboards 4

Reproducing the Issue

  1. Launch Dashboard Design
  2. Create several queries in Query Browser containing BW variables
  3. For each BW variable, use the Query Prompt Selector component and bind it to the respective BW variable
  4. Preview the Dashboard


  • By Default, The List Of Values (LOVs) for the Query prompt selectors are automatically retrieved during initialization of the dashboard
  • The HttpWatch log will show several  'getLOV' calls during the initialization of the dashboard


  • This is By-design


  • Use the List Builder component instead of Query prompt selector (but that would mean you need to retrieve the LOV via another bex query first in order to feed in the List builder): See attached example

See Also

KBA 1927274 


Dashboard, BI41, slow, time, delay, BW, initialise, load, open , KBA , BI-RA-XL , Obsolete: BusinessObjects Dashboards and Presentation Design , Problem


SAP BusinessObjects Dashboards 4.0 ; SAP BusinessObjects Dashboards 4.1