1. Categories >> Software >> Data Warehouse >> Business Objects
  2. Suggest New Category

Report have 10000 records,how to restrict the end user to 1000
Records?

Question Posted / riaz

Answers were Sorted based on User's Feedback



Report have 10000 records,how to restrict the end user to 1000 Records?..

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

Report have 10000 records,how to restrict the end user to 1000 Records?..

Answer / harsha

set max rows limit in universe->properties->controls

Is This Answer Correct ?    4 Yes 0 No

Report have 10000 records,how to restrict the end user to 1000 Records?..

Answer / guest

In the report go to edit query in properties tab there ucan edit.

Is This Answer Correct ?    5 Yes 3 No

Report have 10000 records,how to restrict the end user to 1000 Records?..

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

Report have 10000 records,how to restrict the end user to 1000 Records?..

Answer / rajuallinterview

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

Report have 10000 records,how to restrict the end user to 1000 Records?..

Answer / shikha

Can anyone tell me whats the maximum no. of row limit for bex query?

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Business Objects Interview Questions

Once the project is submited to the Client. Client says that report is taking long time to run? Where u need to check?

2 Answers   Wipro,

How to execute the MACRO through Infoview?

1 Answers  

How to add additional objects or tables into the universe,and what are steps we need to follow to achieve the above task.

1 Answers   Patni,

how u restrict the values?to display 5 values insted of 10 values?

4 Answers  

What is #DATASYNC error how to remove it?

2 Answers   IBM, TCS,




Can any one gve me the complete information abt Certfication of Business Objects ?

2 Answers  

What are templates? Explain what you have created?

1 Answers  

Explain about a tricky situation for which you found a very simple solution?

0 Answers  

What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?

0 Answers   HCL,

I have only 1 dataprovider and using that i have to create 2 tabular report on Webi on same page. One report will display all the salary details and other report will display only max salary. How will you achieve this.

2 Answers   L&T,

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!!!

0 Answers  

Is it mandatory to give a cardinality ? If cardinality is not given what will happen?

4 Answers   Infotech,

For more Business Objects Interview Questions Click Here
Categories