DEV Community

Luca Liu
Luca Liu

Posted on • Updated on

How to Change Number of rows fetched by SAP BusinessObjects Report?

Why need to change the limit of rows from a universe?

By default, a universe is limited to 5000 rows of data. If your BO Report exceeds the 5000 rows, you may miss out on critical data or insights. Therefore, changing the limit of rows from a universe allows users to access and analyze a larger set of data, thereby enabling more comprehensive and detailed reporting and analysis within SAP BusinessObjects.

How to change the number of rows from a universe?

To change the number of rows fetched by a SAP BusinessObjects Report, you can follow these steps:

  1. Open the universe in the Information Design Tool

Image description

  1. Please choose the universe you wish to modify and access the relevant Business Layer within the universe. Then, remove the restriction on the Limit size of result set in Query Options, or input a larger value.

Image description

SAP BO default execution time

The default execution time for a universe is limited to 10 minutes. If the running time for the result exceeds 10 minutes, then we need to disable the Limit execution time to in Query Options, or input a larger execution time.


Explore more

Thank you for taking the time to explore data-related insights with me. I appreciate your engagement.

🚀 Connect with me on LinkedIn

🎃 Connect with me on X

🌍 Connect with me on Instagram

Top comments (0)