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

Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?

801


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...

1920


What is the difference between business requirement document and use case document.

772


in sap bi we have wad, then why we go for sap bo

3026


Explain is data mart?

752


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...

1834


How to execute the plsql procedure from the report by clicking with mouse?

801


Explain about a task that really tested your analytical abilities?

997


is it possible to export the webi reports to crystal reports?with out using businessview?

2026


Explain what task is 98% of the required work of a business analyst?

776


What we need to discuss with designer before starting the universe designing.

2023


What are the data types present in bo? What happens if we implement view in the designer and report?

791


Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye

1619


What task is 98% of the required work of a business analyst?

769


What is package in BO

2912