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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...

1725


Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...

1626


how to create metric universe ?

1897


Explain about alerts in bos, under what situation we need to use alerts?

558


Can we Save (save as) WEBI Doc as DESKI?

7077






Explain about a time when you discovered a more efficient way to do a work task?

640


explain in detail about type 3?

631


how to create reports on screech?

2078


What is difference between webi and infoview?

617


what is universe null

1991


Explain is data mart?

595


Hi, I would like to know how is the integration if we want to use Oracle Essbase as the Cube Engine, and present the Cube by Business Objects Presentation Layer? Can Oracle Essbase be integrated with Business Objects? Thanks,

1583


webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??

3925


Explain in detail about type 1?

657


Can Bo generates the Report from the cubical data Explain?

1628