on 08-11-2015 8:26 PM
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
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
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.
<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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
Hi anuraag
you should change query limit at Universe level parameters, then you will overcome this issue
Regards
Bose
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 3 | |
| 3 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.