1. Categories >> Software >> Data Warehouse >> Business Objects
  2. Suggest New Category

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

Question Posted / rameshbabu.katikireddy

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

CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN

1832

IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY

9625

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)?

665

what is universe null

2077

What is aggregate table and aggregate fact table ... Any examples of both?

696




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

4022

Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?

703

How to sort the dynamic objects alphabetically on the Universe based on and SQL Server

1926

how get the grand total in master-detail report?

1898

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

710

Give some information on report bursting?

647

Its regarding Javascript coding for customization in BI4 reports. We need to have all the options disabled in the report except the option to Export(save the report in computer in Excel/pdf formats). I am able to hide TopBar,TabBar,Left Navigation etc but I need "Export" option to be displayed to the users in Read mode. Can this selective "hiding" be achieved?

1582

Explain difference between zabo and webi?

756

please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.

1630

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

1914