Am I missing something very obvious? I want a default list of values for an object. Set up in Designer, displayed the list, set it to export the list with the universe, exported universe OK.
When I try to create a webi report using the LOV, it refreshes automatically (I’ve NOT set it to do this in Designer). It will keep the list for the user session & report, but doesn’t cache it anywhere. As soon as I close and re-open the report, it refreshes the LOV again, which can take a minute or more.
I know in v6 full client, the LOV was stored on the pc and re-used. There must be a way in XI of storing the LOV with the universe for all webi users? The LOV doesn’t change very often but it is large. What haven’t I set or done?
Unless its been fixed recently, XI R2 does not use the LOV text files produced by Designer. Webi queries the database to produce each LOV list.
You may also want to watch out for the LOV list window not appearing in Webi. The LOV list window may fail to appear in certain situations when you have a customized LOV. Creating a simple query condition by picking a value from the object’s LOV, fails for me on some objects. But if I use that same object for a prompt, the customized LOV’s list window will always appear when I refresh the report.
I didn’t know that. So it’s a waste of my time exporting LOVs with the universe then?
So how would I use a customised LOV with webi, if I can’t attach it to the universe? Never done customised LOVs before. I’m trying to create some standard reports with everything selected at runtime via prompts but at the moment, it’s taking 5 minutes or more to generate all the LOVs - before the report even starts to fetch the data!
Yes, for Webi XI currently its a waste of time to check that “Export with universe” checkbox.
A customized LOV is when you hit that “Edit…” button and make some change to the default LOV. For example, displaying descriptions from a description object beside the codes displayed by the code object.
If your LOVs are taking a long time to generate, you could customize your LOVs for those objects and bypass the problem. Create a table that is your LOV list. Add this table to your universe. Then edit the LOV and use this quick LOV object instead of the normal object. So your object will show an LOV list that is actually coming from a different, much smaller table.
Search BOB, there have been other discussions of this.
For anyone who has similar problems, this is what I’ve come up with:
Generated all my LOVs in Designer (via TOOLS/LISTS OF VALUES
Set all the objects to export with universe & exported universe to CMS
Now despite the known apparent limitations of XIr2 webi LOVs, I found this post
& did a bit of testing.
Set up webi report with lots of prompts & LOVs
Set prompt properties (is this new to XI or a webi feature?) to Prompt with List of Values and Select Only From List
Ran report & sat around for 10 minutes while webi regenerated all the LOVs again. Saved report.
Logged out and back into webi as a different user with refresh-only rights. Opened report as this user and the LOVs were still there (full hit, not just the ones selecetd at last run time).
Currently working on a test system and our servers are down each week - therefore I reckon that we have the same setup whereby there is an LOV cache held on the server and it clears when the servers are rebooted.
Hopefully when we move over to live, servers will stay up more often and the problem will therefore go away!
I see that you mentioned about a problem with the customized LOV hanging when trying to select values from list,but the LOV works fine when defined as a prompt.
We are having similar issues with a particular universe.Most of the objects when used in the filter pane (WebI) to define “in list” values,the LOV hangs.
But when the same object is used in the filter pane (WebI) to define as a filter,the LOV is generated while refreshing the reports.
Apart from the creation of a separate table for the LOV,is there any other options that you had tried or worked with.
We also are fighting with caching problem. WebI R2. First time we had only SP3 and the LOV’s have not been cached. Maybe only inside of a session, if you call the same lov twice or more. But after logging out and in the WebI “forgot” the lov’s and calls them from DB again.
Ok, we’ve installed SP4+SP5 and it looked good. First time, exactly one day WebI has cached lov’s properly and showed them very fast. But from second day the caching seems to be disabled “again”. We didn’t change anything on server this time.
The server doesn’t cache for all fields. some of them are set as “export with universe” another have this flag not set. We have as pilot R3.1 on antoher machine and it caches.
Another oddity: this day, after installing of SPs when the cachinf worked, it has worked only for “Windows NT” user, that are user from Windows domain. For technical BO-User (login with “Enterprise”) caching was always “disabled”.
(BOB member since 2005-03-01)
(BOB member since 2004-02-05)
(BOB member since 2005-03-01)
(BOB member since 2004-01-09)
WebI has cached lov’s properly and showed them very fast. But from second day the caching seems to be disabled “again”. We didn’t change anything on server this time.