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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

How many universes can be created in a project?

599


What are the steps to do to use alerts in bo?

633


Did you face any problems while creating reports? Name? Solutions?

3260


Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?

602


Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?

542






Explain when we use aggregate awareness function in designer?

590


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


How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?

577


Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?

818


Explain what three things do you consider to be the most important factors for a manager?

551


Explain what is aggregate table and aggregate fact table ... Any examples of both?

609


Can we configure two instances of CMS pointing to two different CMS system databases?

1490


Regarding Hyperlinking in Business Objects. We have a few reports in QA environment where a number of hyperlinks are employed using OpenDoc function.In some of the reports,hyperlink is used to move to another tab within the same report.The formula used include "DocID" and ReportName="tab name".This works fine but now,for the PROD move,this will not work as the Doc Ids are subject to change. Is there a way to overcome this?Without DocID,how will move to a particular tab? Thanks in advance

4448


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

7075


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?

3132