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 |
What is batch processing in Business Objects?
how many user were there
if we run a report it is taking so much time to display the report,what to do to increase th performance of the report
how to creat 2 way drilling mode.can any one know this
what is prompt? Cascading prompt? Syntax
draw the architecture of bo
How do you find what type of trap is there by seeing the report?
What is metrics?
I want to do on drill calculation? Actually My report is like Continent Amount(Global Currency in dollar) ASIA 200 UK 100 On Drill ASIA Country Amount INDIA 5712(120*47.6) SINGAPORE 128(80 * 1.6) On Drill INDIA State Amount DELHI 3712 CHENNAI 2000
which is the best way to resolve loop context r alias why?
what is the difference between breaks and sections?
Report have 10000 records,how to restrict the end user to 1000 Records?