How can we limit the total rows pulled in a Report to 50 rows, even though the report runs with default selections and retrieves more than 50 rows?
In the Prompt created there is an option of Rows per page but that it not limiting the whole date to be 50 rows though even if i change it to 50.
Hi,
whats the granularity of the data you retrieve? There are coming several ideas to mind...
1) in the framework manager, you can set limits for amount of data the sql queries...but this will be set for the whole package, therefore you will need a package for this report ince case further reports dont neet this limitations. the option you want to look for is to be found in the governor section ("Maximum number of Rows Retrieved.")
2) you might wanne work with the rank() function (if relational) or topcount (dim.) (if you didnt use this function yet, just search in the top right search box for "rank")
3) also, you can use native sql, and use the top X - function as in normal sql clients
4) i think you can use stored procedures as well in FM, but to be honest ive never worked with that solution b4..
gl =)
cheerz