Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 6 Answers
- 10043 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
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 |
why we use aggregation in lower level
any of the person working on encyclopedia? give the explanation briefly?
Please Send to my e-mail Interview Questions With Answers , Technical Test Questions With Answers and Code Snippets Of Business Objects - Dev , Business Objects - Reporting Analysis .
How do you restrict access to rows of a database?
What is the difference between business requirement document and use case document.
what is fantrap and chasmtrap ?
Can any body Explain me what are the critical problems you have faced in the designer and repoting level in the real time environment?
hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message
How to create Generic TIME CLASS, which includes Objects Year,Month and Qtr?
what is performance tunning in BO in report level& designer level?
Hi friends, I am trying to create OLAP connection in IDT. I am getting error "error code:405 METHOD NOT ALLOWED" I am using "http:<servername>/olap/msmdpump.dll" I am using ms sql server 2012 -- cube
What are the Different Data Providers support in Web Intelligence and DeskTop Intelligence?
Teradata 
