LOV's in BO Universe . UNV
We have an objects in the BO universe (.unv) in which it has LOV's of more than 1+ million values. Recently the universe got migrated from XIR2 to XI4.1 SP6 . In XIR2 we don't see any issues when this particular object is selected as filter and chosen the values from the list.
In XI4.1 we have followed the same steps and it shows partial values message at the bottom as shown in the attached image.
Basically, I would like to know how to get this rid of partial values without increasing the "WebiParamMaxLovSize" drastically in the BO server and also without archiving the data in the database. Also, it is taking more than 5 min to fetch all the LOV's for this objects.
So, I want the various options on how overcome this partial values issue.
Please let me your thoughts on the same.
Thanks for your help!