SAP Knowledge Base Article - Preview

1710381 - When refreshing a Web Intelligence report, the prompts do not show all the values of a BEx Query prompt if the number of values exceeds the batch size (1000 by default)

Symptom

  • List of Values not “chunking” in Web Intelligence reports based on BICS with BEx Query LOV in Web Viewer, only first batch of values are displayed 
  • When refreshing the WebI report, the prompts do not show all the list of values
  • Users can still search and find the desired value and reports run fine

Some background information:

  • WebI "chunks" based on the batch size set in the Web Intelligence Processing Server properties, it is set to 1000 by default
  • The batch size only limits how large each section of LOVs is displayed, not the total number of values
  • If there are 5000 values, then 5 batches of 1000 are displayed in the prompt member selector


Read more...

Environment

  • SAP Business Intelligence 4.0
  • SAP BusinessObjects Enterprise
  • Web Intelligence
  • SAP BW BEx Query

Product

SAP BusinessObjects Business Intelligence platform 4.0

Keywords

WebI, WebIntelligence, Web Intelligence, batch, chunk, lov, list of values, BEx, query, prompt, parameter, refresh, display, show, not showing, disappear, gone, available, larger, big, huge, lots, many, thousands, mandatory, optional, number, a lot, alot, limited, truncated, navigate, folder, section, ADAPT01634856, ADAPT1634856, ADAPT, 01634856, 1634856 TE: 5050067458 , 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.