Photo by Markus Spiske on Unsplash
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:
- Open the universe in the Information Design Tool
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 toin 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 or X(@Luca_DataTeam). You can also catch glimpses of my personal life on Instagram, Happy exploring!👋