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 we go for OLAP , and When we go for OLTP for generating the reports ?
Explain about a tricky situation for which you found a very simple solution?
I need to modify Web Intelligence Report, I need to Add 7 columns in WEBI Report-Java Pannel, so i could Add only 6 Columns in the Webi-Java Pannel as one X Table - X Column is not available in the Universe. I was advised that i can do it with Free Hand SQL in Web Intelligence even X Table - X Column is not available in Universe. Please kindly let me know how to implement the same
wat is the difference between full clinet report and thin client report?wat is the difference between desktop intelligence and web intelligence?
what is the syntax for aggregate awareness?
3 Answers Exilant, i-Tree, Wipro,
CAN A REPOSITORY CONTAINS REPORTS?
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
please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.
1) How to get multi values in a single prompt? 2) How to get ALL in @prompt? 3) Select 1 from fact table? What will be the result? 4) I have created 1 universe say A and generated 100 reports on the universe? Later i had renamed the Universe as A1 and added some objects? Now how i will get the newly added objects in old reports?
Can We customize the Business Object infoview in BO?
What is difference between webi and infoview?
What is broad cast agent?