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

Categories >> Software >> Data Warehouse >> Business Objects
Suggest New Category

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

Question Posted / riaz

6 Answers
9630 Views
I also Faced
E-Mail Answers

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?