how to limit number of rows in a report in business objects
using webi?
- 3 Answers
- 18298 Views
- Cap Gemini, TCS, I also Faced
- E-Mail Answers
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 |
Which command using Query Analyzer will give you the version of SQL server and operating system ?
What happens in BO when a user logs in to Infoview and a rich client like webi?
Report have 10000 records,how to restrict the end user to 1000 Records?
what is crystal reports?how to migrate them?
HOW TO EXPLAIN SHORT CUT JOIN AND THETA JOIN?
How we drill up week to month?
Can any please explain FOR EACH AND FOR ALL?
User name and password is saved by Business objects when we create repository. and this username and password is saved in Table obj_m_actor table in repository. The password in incrypted form. It is possible to Dycrypt That Password.
1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?
How many universe dfi you create if you have 2 years of experience in BO
difference between web intelligence,crystal reports and desktop intelligents
what is the necessity of oracle for business objects,why the interview panel is concentrating on oracle very much? Just we need the commands using select,joins? why they r asking about cursors,triggers etc..can any body answer me ..........Thanks in advance prakash
Teradata 
