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 |
when I am trying to schedule the report its running faster then I tried to run it manually?? why is it so that there is difference of time between scheduling and manual run for report
what are the debuggings in the business objects?
How do you restrict access to rows of a database?
what is dashboards? what is metrics?
What is the Difference b/w Server based Ranking and normal Ranking?
Is it mandatory to give a cardinality ? If cardinality is not given what will happen?
why measure objects are semantically dynamic?
what is the difference b/w the refresh and buffered data?
What is the pragma?
Is import wizard, report conversion tool, report comparison tool, security viewer ---- where all r migrating tools. whether all the tools available in BOXIR2? ..
How to fix the order of Prompts? How to assign the default value in prompt?
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..