How to Modify the Number of Rows Fetched by SAP BusinessObjects Report

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

   

   
   

2. 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.

   

   
   

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.

Thank you for taking the time to explore data-related insights with me. I appreciate your engagement. If you find this information helpful, I invite you to follow me or connect with me on LinkedIn. Happy exploring!👋