Skip to Content
Former Member
Dec 27, 2009 at 12:11 PM

Performance issue using selection from LOV


We created a BOBJ UNIVERSE over a Bex Query based on BW-DSO.

The Bex Query has a filter object for selection during executing time.

This Object is marked as "searching from MASTER DATA" on the BEX query.

When a BOBJ query is operated on the UNV, it takes several minutes to get the LIST OF VALUE of the filter object.

The list of values is showen from the DSO and NOT from the MASTER DATA.

If we operate the BEX query in BW, we receive the LOV in seconds. (from the Master Data).

Our platform is Business Object XI 3.1 SP2 includes SAP integration KIt of the same level.

BW 7.00 support package 22 (SAPKW70022).

The DSO contains about 2,000,000 rows.

Any suggestion how to improve performance time for BOBJ query or how to enforce it to get the LOV from BW MASTER DATA ?