Report have 10000 records,how to restrict the end user to 1000
Records?
Answers were Sorted based on User's Feedback
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 |
Answer / guest
In the report go to edit query in properties tab there ucan edit.
| Is This Answer Correct ? | 5 Yes | 3 No |
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 |
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 |
Answer / shikha
Can anyone tell me whats the maximum no. of row limit for bex query?
| Is This Answer Correct ? | 0 Yes | 0 No |
GENARALLY HOW MANY UNIVERSES ARE CREATE FOR EACH PROJECTS?
What is top business?
While at local system, u could get all records say 1 lakh, but while at server u got only 50000 records when u run the report. What could be the causes. How to Rectify this.
what is the necessity of oracle for business objects,why the interview panel is concentrating on oracle very much? Just we need the commands using select,joins? why they r asking about cursors,triggers etc..can any body answer me ..........Thanks in advance prakash
What services the broadcast agent offers on the server side?
hi my question is in a report table how can we write table header without using of individual cell.can we merge column cells togrther??
Can we link the oracle and excel universess?
How to resolve the partial result error in the report
what are the day to day activities of BO administrator ?
What is meant by data federator and what is the use of it?
Explain about a tricky situation for which you found a very simple solution?
Explain how to execute the plsql procedure from the report by clicking with mouse?