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 how to execute the plsql procedure from the report by clicking with mouse?

594


Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?

674


Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?

619


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

597


What is package in BO

2680






How many universes can be created in a project?

595


hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message

1569


Explain when we use aggregate awareness function in designer?

581


What is thumbnail?

573


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?

3125


Difference between zabo and webi?

634


What is report template in b.o?

578


Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.

3840


Explain in detail about type 2(scd),

587


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

1812