Limit number of rows in Webi report in SAP BusinessObjects

If you using Universe as the source, In UDT this can be defined at Universe level. You can limit the size of result set in Universe Parameters -> Controls

In Query panel, you have an option to set the limit on rows retrieved for each individual query. This setting is called the Max rows retrieved.

This option is linked to each individual query, not with Webi document as a whole. When your document has multiple queries, you need to set the Max rows retrieved for each of them.

Ayyan

Published on 14-Dec-2017 06:48:02

• Related Questions & Answers
• Show creator name in SAP WEBI report
• Sorting Prompt values in SAP BO Webi report
• Passing multiple parameters in SAP BO Webi report
• Handline #Multivalue Error in SAP BO Webi report
• Apply sorting on Date in SAP BO Webi report
• Forcing SAP Webi report to show specific data
• Finding CUID in a SAP BO Webi report in Formula Editor
• Read a date filter as input in WEBI report in SAP BO
• Creating a Dashboard from Webi Report
• How to find a constant in a string in SAP BO Webi Report
• Count distinct entries in SAP BusinessObjects
• Connection SAP HANA with BusinessObjects
• Using SAP BusinessObjects dynamic recipient
• Get total number of rows while using LIMIT in MySQL?
• Getting a carriage return of report field in SAP Crystal Report