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

Report have 10000 records,how to restrict the end user to 1000
Records?

Question Posted / riaz

Answers were Sorted based on User's Feedback



Report have 10000 records,how to restrict the end user to 1000 Records?..

Answer / nitish

select parameter in universe go to control tab select query limit size set to 1000 or 10000 depending upon the requirement

Is This Answer Correct ?    5 Yes 0 No

Report have 10000 records,how to restrict the end user to 1000 Records?..

Answer / harsha

set max rows limit in universe->properties->controls

Is This Answer Correct ?    4 Yes 0 No

Report have 10000 records,how to restrict the end user to 1000 Records?..

Answer / guest

In the report go to edit query in properties tab there ucan edit.

Is This Answer Correct ?    5 Yes 3 No

Report have 10000 records,how to restrict the end user to 1000 Records?..

Answer / tarukhemu

You can go to
Tools > Manage Security > Manage Access Restrictions > New > 'Controls' tab > Limit size of result set to
This will allow you to set the row limit for only a particular user rather than for the whole universe data(which can be done as File >Parameters >'Controls' tab)

Is This Answer Correct ?    0 Yes 0 No

Report have 10000 records,how to restrict the end user to 1000 Records?..

Answer / rajuallinterview

we can manage max no of rows in universe and reporting side.. in universe go to row level and in report goto proprties of report

Is This Answer Correct ?    0 Yes 0 No

Report have 10000 records,how to restrict the end user to 1000 Records?..

Answer / shikha

Can anyone tell me whats the maximum no. of row limit for bex query?

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Business Objects Interview Questions

Hi Can anyone tell me what is Divergence in Business Object Universe Designer. Thanks, Sheik

1 Answers  

What is Cartesian product?

14 Answers  

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

0 Answers  

what are the complex reports you have created. Tell me with example?

7 Answers   Insurance, TCS,

What is a universe?

8 Answers   TCS,




i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?

0 Answers   Patni,

What is drill across ? can anybody explain me in detail?

1 Answers  

HI EVERYONE I HAVE A QUESTION I FACED A QUESTITON FROM INTERVIEWER IN WEBI REPORT CREATING CROSS TAB REPORT FOR EX: YEAR IS COLUMN WISE AND MONTH IS ROW WISE AND INTERSECTIO IS REVENUES . HE WANTS BREAKS AT FIRST 3 MONTHS IN ROW LEVEL .. COULD U PLEASE TELL ME IF ANYONE KNOWS..

4 Answers   IBM,

What is meant by Adhoc reports?Can any body will explain with examples...Thanks in Advance .........prakash

7 Answers   TCS,

what is casual dimension?

1 Answers   CA,

how to create metric universe ?

0 Answers   TCS,

How to make hilight the whole row by using ALERTS asof revenue is more than xxxxx?

1 Answers   Emphasis,

For more Business Objects Interview Questions Click Here
Categories