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
- 10042 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 |
1.what is the use of migration.(converting one version to another) 2. what r the migration issues faced while migrating from Bo5.x to BOXIR2 n how 2 resolve it. 3. provide some .ppt/material to understand abt migration easily.
While at local system, u could get all records say 1 lakh, but while at server u got only 50000 records when u run the report. What could be the causes. How to Rectify this.
how to restrict up to three levels in hierarchy when u do drill mode?
How do you restrict access to rows of a database?
I have a report with some hyperlinks,any issue will i get when i migrate this report?
What is the drill up , drill down, drill by , drill trough ?
can we create aliases for every table beforehand? if yes whar are the disadvantages?
WHAT ARE THE INDEXES THAT SUPPORT DATA WAREHOUSING ? Thanks In advance Prakash
Explain the data types present in bo and what happens if we implement view in the designer and report?
What is Custom Sorting? In development environment we had applied custom Order on Month which is having the following list of values September,October,March,August and December only.But in Production environment Month is having all LiSt of Values like 12 MOnths(Jan to Dec).So ,How it will effect the Sorting in production environmentof universe and as well as in reporting????? Thanks in advance.
4.what is aggregate awareness ? how do we use ? where do we use ?
WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?
Teradata 
