Skip to Content
0
Former Member
May 18, 2010 at 01:08 PM

Partial result set in LOV

36 Views

I am working with BO XI R3 and back end as DB2.

I am facing a partial LOV results set:

From my analysis I have the following:

1)This error occurs with a particular table

2)The number of rows that are being fetched from the database are 44,018,911 rows (nearly 44 million) out of which 178,940 rows are unique ones

3)These rows are not cached/stored daily. Hence each and everytime the report is run it has to fetch from the DB and bring it to the report.

4)On the Universe front, checked with the Universe File-->Parameters tab and "Limit size and time" are unchecked

5)On the report front there is no limiter for the number of rows.

I am not sure but where the tuning has to be done? At the DB front (DB2 is my back end) or on the Universe front (BO XIR3). 1 ) Which would better 2) In case the tuning has to be done on the Universe front how does it need to be done?