cancel
Showing results for 
Search instead for 
Did you mean: 

BO Prompt Lov partial results in webi interactive mode

Former Member
0 Kudos

HI Guru,

I am facing one issue with BOE 3.1 when i drag the object in filter pane , i see Partial results for LOV  when i refresh it it goes in  Rich client but in webi interactive mode its still showing the partial results . can you please help on this

Thanks in Advance

Accepted Solutions (1)

Accepted Solutions (1)

former_member191664
Active Contributor
0 Kudos

Maximum List Of Values Size (entries)

This sets the maximum number of values that can be entered into a prompt.

•          Default: 50000 entries

•          Range: 1000 to 10000000 entries

Note:  This does not set the max number of values that can be returned.  That would be set in the Universe parameters.  This CMC WebI Server setting limits the number of entries that can be entered (selected or pasted) into a prompt.

Below steps are to increase the Maximum List Of Values Size for Webi in Infoview

  1. Login to CMC
  2. Click Servers
  3. Right click Web Intelligence Processing Server and select Properties
  4. Increase value of Maximum List Of Values Size (entries).
  5. Save and restart the Web Intelligence Processing Server.

Note : Setting large number for Maximum List Of Values Size (entries) may affect the performance of Web Intelligence. It is recommended to set the appropriate number by considering system performance.

Below steps are to increase the maximum entries for List Of Values in Web Intelligence Rich Client.

  1. Go to the folder: <install folder>\BusinessObjects Enterprise 12.0\win32_x86\config
  2. Back up this file: webi_client_default_parameters.xml
  3. Modify the webi_client_default_parameters.xml file and find this row:

<PARAMETER NAME="WebiParamMaxLovSize"                                                                     VALUE="50000"            TYPE="long"      ADMIN="true"  />

Modify the value 50000 to a big value such as 10000000.

   4. Save the webi_client_default_parameters.xml file and restart the Web Intelligence Rich Client.

Regards,

Jin-Chong

Former Member
0 Kudos

Hi JinChong Tsai,

I'm facing similar problem with LOV limitation of 50000

however when I try to increase the maximum entries for List Of Values in Web Intelligence Rich Client in the mentioned path I don not have "webi_client_default_parameters.xml" file in it. PFB

Can you please assist on this?

Thanks,

Niki

former_member198519
Active Contributor
0 Kudos

I believe the path mentioned by Tsai is for Business Objects XI 3.1. If you are using BO 4.x version, you can increase this value in Webi Processing Server. Look at the snapshot from the admin guide below

former_member191664
Active Contributor
0 Kudos

check out C:\Program Files\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\config\WebIContainer_ClientDescriptor.xml

regards,

Jin-Chong

Answers (2)

Answers (2)

bosegsap
Participant
0 Kudos

Hi anuraag

you should change query limit at Universe level parameters, then you will overcome this issue

Regards

Bose

amitrathi239
Active Contributor
0 Kudos

Hi,

If partial result error is coming only for LOV then check the properties of Web intelligence server in CMC and increase the LOV limit from 1000 to some different number and restart the server.

if happening for report data also then Uncheck the time-out and retrieve number of rows restriction in universe and webi report query panel.

Universe-Universe parameters

Webi->webi query properties.

Amit