Web Intelligence Report which has more than 5000 rows does not display.

Document ID : KB000049799
Last Modified Date : 14/02/2018
Show Technical Document Details


This issue occurs because of the option "Limit size of result set to" is set to 5000 by default.


To resolve this issue, increase the value of "Limit size of result set to" to 10000 by following the below steps:

  1. Login to the designer with administrator credentials.

  2. Click on File and Import the Universe. Once imported, click on File and then Parameters.

  3. In the Universe parameters window, click on controls tab and check the option "Limit size of result set to" and change the value to 10000 as shown in the below screenshot:

    Figure 1

  4. Click on OK and then click on File and then click on Export.

  5. Once export in the designer is completed, login to Infoview and run the report.

You should now able fetch more than 5000 rows.