how to limit number of rows in a report in business objects
using webi?
- 3 Answers
- 18979 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 |
1) How to get multi values in a single prompt? 2) How to get ALL in @prompt? 3) Select 1 from fact table? What will be the result? 4) I have created 1 universe say A and generated 100 reports on the universe? Later i had renamed the Universe as A1 and added some objects? Now how i will get the newly added objects in old reports?
What are templates? Explain what you have created?
how to do Ad-hoc reporting ?
WHAT IS CARDINALITIES OF JOIN?
What are the different types of Filters available in BUSINESS OBJECTS?
Suppose we had a scenerio like in an universe there are nearly 250 objects but only 50 objects data is updated frequently so is there any way to overcome it.(Birla Soft,)
Iam having an report there four cloums and n number of rows if i click ang one cell the report want to go to another report page which gives the detail of the cell which i click pls help me with example
Example of how the fantraps and chasm traps works?
Can we link the oracle and excel universess?
Briefly describe the steps you would take to use an Excel file as data to join a Business Objects data provider in a report? Thanks in advance....
date format in report like (22/5/2010 "3:20:15 am") like this i want to remove 3:20:15 remove from report how can we do this in bo xi r2
what is meant by slowly changing dimensions?
Teradata 
