how to limit number of rows in a report in business objects
using webi?

Answers were Sorted based on User's Feedback



how to limit number of rows in a report in business objects using webi?..

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

how to limit number of rows in a report in business objects using webi?..

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

how to limit number of rows in a report in business objects using webi?..

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

Post New Answer

More Business Objects Interview Questions

what are the roles and responsibilities of BO Administrator ?

1 Answers   OCS Infotech, TCS, Wipro,


How to Implement the the Built-in Strategy Script in BO Designer?

2 Answers   Infosys,


I WOULD LIKE TO GO FOR ONLINE CERTIFICATION FOR BUSINESS OBJECTS 6X. CAN SOMEONE GIVE ME IDEA ABOUT. Thanks in advance

5 Answers   TCS,


What are the differences between webi and deski of XI R2 not the earlier versions

1 Answers  


I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!

0 Answers  






How to resolve the partial result error in the report

4 Answers   Keane India Ltd,


What is the aggrigate navigation ? can anybody explain me with some practical example?

1 Answers  


How we will see which trap(Chasm trap or Fantrap) was used in the Universe ?

2 Answers   Wipro,


i Have created the universe in which i have one table and different derived tables from the same table i am supposed to create report from the same universe which should dispalay the duplicates rows, but all the time i run the report i am not getting the duplicate rows i have checkd the duplicate report option too in report.. is there problem with universe or report,.. can any body help?

2 Answers  


How to fix the order of Prompts? How to assign the default value in prompt?

2 Answers   Mind Tree,


IN BO i have data source having the data like "abc" and after creating the Report on that datasource the data unmathed like "def".what will you do ? please anybody help me

2 Answers   Accenture,


tell me about aggregate awareness in detail?

2 Answers   Cap Gemini,


Categories