Skip to Content
0
Former Member
Jan 17, 2012 at 09:20 AM

Webi List of Values taking long time to generate

100 Views

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