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
- 10203 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 |
I have a situation like one manager can have multiple learners under him. each learner will registered for more than one certifications . their statuses for different courses like completed, inprogress, dropped, no certifications. the question is i have check for each user for statuses if he had some completed certifications i have to get latest completed date and omit all other stauses. if he had no complete staus then i have to get latest inprogress record based on date. like this i have to select only one record for user. but i am getting one row for each status. among all completion status one record, for all inprogress one record, for all dropped status one record. how can i show only one record
what is the difference between bo and cognos?
I have saved one file in GMT as a standard time and the server must convert it into local time. How to do it?
what is the syntax for aggregate awareness?
3 Answers Exilant, i-Tree, Wipro,
I have all the below SAP – Business Objects Certification latest Dumps, I scored 100 % Score with these Dumps
WHAT ARE THE TYPES OF UNIVERSES?PLZ EXPLAIN IT
9 Answers Business Intelligence Analytics, SRA,
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
Can Bo generates the reports from cubical data ? Explain?
How can we acheive Correlated sub-query in Designer?
2 Answers Infosys, TCCX, Wells Fargo,
HI, can anybody explain me how performence will decrease if we create objects using derived tables ?
If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?
What is the pragma?
Teradata 
