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

Say, the query gets executed and we got the results. In
case if we have a large number of rows, how can we know the
exact no of rows returned?

Question Posted / ravindra81

Answers were Sorted based on User's Feedback



Say, the query gets executed and we got the results. In case if we have a large number of rows, ho..

Answer / pers

From the data manager tab we have to know the no of rows
returned and the time taken to run the report.

Is This Answer Correct ?    3 Yes 0 No

Say, the query gets executed and we got the results. In case if we have a large number of rows, ho..

Answer / surender vanga

click on any column in result set, right click and select
countall. this will display the total number of columns in
the result set.

Is This Answer Correct ?    2 Yes 1 No

Say, the query gets executed and we got the results. In case if we have a large number of rows, ho..

Answer / tarun

Referring the data manager tab is the best way to determine
the number of rows returned by a query. This is because
applying the CountAll feature will cause to suppress/hide
all duplicate rows (if any) and give the incorrect number of
rows returned.

Is This Answer Correct ?    0 Yes 0 No

Say, the query gets executed and we got the results. In case if we have a large number of rows, ho..

Answer / john

Use summary tab

Is This Answer Correct ?    0 Yes 0 No

Say, the query gets executed and we got the results. In case if we have a large number of rows, ho..

Answer / parimala

using the rownumber function(by creating an object)and then if u dont need the rownumber(), just hide the column

Is This Answer Correct ?    1 Yes 1 No

Say, the query gets executed and we got the results. In case if we have a large number of rows, ho..

Answer / deanna

Once you have signed in to BO InfoView Click
on “Preferences” on the upper right hand corner.
Expanded the Web Intelligence section
Click on “Interactive” under “Select a default view
format:”
Then click “OK” at bottom of Screen
In InfoView Interactive View mode, you can see the number
of rows returned on the Data Summary tab.
Note that you can ONLY see the number of rows in InfoView
Interactive, NOT in WebI.
Notice the gray block with the black arrow on the left side
of the report
Click on the arrow it’s very small
The Interactive view panel opens. Click on the Data
Summary Icon. The number of rows returned is listed in the
top portion

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Business Objects Interview Questions

can we cretae views in universe level?

2 Answers  

What are the data types present in bo? What happens if we implement view in the designer and report?

0 Answers  

HOw do u migrate from old version to the new version?

1 Answers   AOL,

Can anybody tell me what are the tuning problems?

1 Answers  

what are slowly changing dimensions, confirm dimensions?

1 Answers   Wipro,

what are the day to day activities of BO administrator ?

1 Answers   TCS,

Tell me about a complicated object you have created?

1 Answers  

What is a universe?

8 Answers   TCS,

can anybody tell me about issues faced while creating reports

3 Answers   Accenture,

I have the one Universe. I take the data from the Excel Sheet. Now i want to get the reports from the two.What is the process

2 Answers   Wipro,

what is maximum scope of analysis --> can we define more than 3 levels?

2 Answers   CTS,

How do you restrict access to rows of a database?

2 Answers  

For more Business Objects Interview Questions Click Here
Categories