Skip to Content
avatar image
Former Member

LOV's in BO Universe . UNV

Hi Team,

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!

Issue.jpg (12.5 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Oct 30, 2015 at 11:00 AM

    Hi,

    You can get rid of partial values in Webi report with out increasing "WebiparamMaxLovSize".

    Select the object in Business Layer and navigate to Advanced Options, there you can find "Allow User to search values in the database, check the option for that field.

    In Report Level while refreshing the query, select the prompt and you will find the search button list box, there you select the option as 'Search on Database'

    To Search Text add * Like below

    AYAYA* and hit enter button.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 02, 2015 at 01:55 PM

    Hi Jagadeesh,

    Check what value is set for MAX_INLIST_VALUES parameter in universe.

    Set it to -1 and check if it fixes the issue.

    Regards,

    Yuvraj

    Add comment
    10|10000 characters needed characters exceeded