Hi
We are on BO 3.x
I have a Webi report that consists of two queries which have been merged.
Each query is based on separate Universes, and each of these on separate BEx queries.
These BEx queries are built on fairly large cubes with +/- 10mill records each.
I have created a BEx variable on a common object for these two queries.
When I run the report in Webi and refresh the List of Values for this object, it takes a long time (several minutes) to generate the list.
My understanding is that Webi ignores the "Values in Master Data" setting on the InfoObject or in the BE query and gets this list from data in the InfoProviders.
1) Is there a way to speed up Webi returning the LoVs?
2) If two queries are used in Webi with the same BEx variable, from where is the LoVs generated - both queries and infoproviders? Or from the query positioned on the left in Webi?
Rgds
Anton