how to limit number of rows in a report in business objects
using webi?
Answers were Sorted based on User's Feedback
Answer / santhosh
to retrieve max no of rows or to limit the max no. of rows
before running the report go to properties tab in that we
can set the max no. of rows so that we can retrieve the data
Is This Answer Correct ? | 19 Yes | 1 No |
Answer / kiran
One can use the Data Provider properties -> Set Max rows retrieved -> 65K
Create a variable check =DocumentPartiallyRefreshed()
and add 2 report level block filters
apply check = no to data block &
apply check = yes to message text block.
This should work fine!
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / rameshbabu.katikireddy
I have a requirement where I need to display the WebI Report data only if the number if record is less than 65k.
Incase if the records are more than 65k then the report should be blank and a text message needs to be displayed.
The client dont want to set the number of records either in universe or at the edit query at the report. They want to limit once the report is executed.
Please let me know if its possible to do it at the report level.
posted by
Rameshbabu.katikireddy
jan.11.2012
09767696346
karimnagar
Is This Answer Correct ? | 2 Yes | 3 No |
can anybody explain me in detail about software development life cycle of business objects in detail?
I have 2 structures in universe,but i can't link the structures b'cos no related columns,so what i have 2 do to link dat and if don't link them can i get data of 2 structures in the report that i run?
Ranking feature was not available in WEBI 6.5 version,So how can we get ranking in WEBI 6.5 version?
What is the error that occurs while detecting the cardinalities in the universe pane if we create a join between the normal table and the aggregate table...
why you create universe and creating reports based on that? why dont we go for crystel reports and generate reports directly?tell me the advantages?please answer to this question.
What is the difference between the Webintelligence and desktopintelligence?
What is a category?
define universe parameters?
can anybody tell me about issues faced while creating reports
Is it possible to develop reports without Universe access?
Hi, In BO at universe designer i had four tables which has many to many relationships between the tables. How to fetch the correct results in the report?
whats the diff between break and section