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 |
CAN WE CREATE VIEW IN BO (NOT DERIVED TABLES)?
In a context can i get the data from two different factables by using the single data provider?
I have 2 structures in universe,but i can't link the structures b'cos no related columns,so what i have 2 do to link dat and if don't link them can i get data of 2 structures in the report that i run?
how to sort on a particular object,that object is not picked up while creating the cross tab but we need to sort on the object that is not in the cross tab????
2 Answers Infosys, Keane India Ltd,
what r the universe connection types?
I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!
How to resolve the partial result error in the report
Explain the difference between union and group?
What is security domain in Business Objects?
What is slicing and dicing in business objects?
What is domain? How many are there in a basic setup? What are they?
What is meant by Adhoc reports?Can any body will explain with examples...Thanks in Advance .........prakash