Limit number of result or rows returned in BO using WebI

sap business-objects infoview
maroon picture maroon · Jan 7, 2014 · Viewed 16.8k times · Source

How do I to limit the number of results/rows returned from a query in WebI other than using custom SQL? Possibly something like 'Top 100' records.

I can't change the 'Limit resultant size' in the parameters as I do not want it to affect any other reports.

Thank you in advance :)

Answer

DocZerø picture DocZerø · Jan 7, 2014

In Web Intelligence, you can set the number of rows that the query provider should retrieve. This setting is called the Max rows retrieved. From the Webi user guide:

The Max rows retrieved query property determines the maximum number of rows of data that are displayed when a query is run.

If you only need a certain amount of data, you can set this value to limit the number of rows of data in your document.

Max rows retrieved is applied at the database level if the database supports it. If not, rows are discarded after retrieval from the database.

Note: this setting is linked to the query, not the document as a whole. In other words, if your document has multiple queries, you have to set the Max rows retrieved for each of them.

Related questions

How to Hyperlink to a Business Objects Report in Infoview

Is there a way to craft a hyperlink that connects to a Crystal Report or Webi within Infoview? Ideally, unauthenticated users would be challenged with Infoview security and then redirected to the report. Thanks!

Read More
Web Intelligence report error. #MULTIVALUE error

I've run into an issue with the WEBI report I am making. Here is the code in question: =If([Group Change Task Status Desc] = "Open") Then([Count of GCT]) ElseIf([Group Change Task Status Desc] = "Complete" And [SH Open Date …

Read More
BO Reports: have a formula produce a null

I need to have a formula produce a null in some cases, numeric in others. Then I'll use number formatting to present accordingly. Something like this: =If(Count([Product Id]) = 1) Then null Else [Amount] Unfortunately null is not a recognised …

Read More