Partial result set in LOV

[Former Member]

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?

[Former Member]

Are you getting this one on the Webi report Lovis or Deski Report

If its a webi report you need to change in the Webintelligence Processing server Properties.

The Default vales fro the Maximum List of values size entries is 50000 Lovs

[Former Member]

It is a Web I report.

Let me check about this and get back. Apart from this what objects are pulling large data I have checked "Export with Universe" option.

Thanks for the reply.