We are on XI 3.1 and using Webi, we have a couple of dimensions which when we try to do a 'list of values', we are never getting a response it is just 'Loading, please wait...' even leaving this for over 30 minutes does not get any results. If I get the list in Designer it responds in approx 5 seconds, if I do it directly in SQL it takes 5 seconds (there are 70000 rows).
This is starting to get very annoying to all our users as at the moment all I can do is to stop them being able to use LOVs.
Can anyone help please ?