Description:
This issue occurs because of the option "Limit size of result set to" is set to 5000 by default.
Solution:
To resolve this issue, increase the value of "Limit size of result set to" to 10000 by following the below steps:
- Login to the designer with administrator credentials.
- Click on File and Import the Universe. Once imported, click on File and then Parameters.
- 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:
<Please see attached file for image>
- Click on OK and then click on File and then click on Export.
- Once export in the designer is completed, login to Infoview and run the report.
You should now able fetch more than 5000 rows.