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?
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 |
Ihave one report.Now i want to display that report as one row as one color and another row as another color.The entire report i need like that
Hi All, I have found out this site very interesting and knowledge sharing site.I was wondering if you can tell me where I can get study materials for the BO XI 3.1 or suggest me the one that you have taken recently. Regards, Ace
how to do Ad-hoc reporting ?
In Business Objects 4.1 version what is the alternative name for broadcast agent?
can you use inputbox in BOXI. e.g. checkbox,textbox etc.
HI ALL, CAN ANY PLEASE TELL ME HOW TO CREATE HYPERLINKS IN WEBI.THANKS IN ADVANCE
Can any body will explain about sarrogat key? Thanks in advance...........Prakash
What services the broadcast agent offers on the server side?
Any body help me...what are challenges did u face in Business object project?
what is meant by scorecards?
What are the differences between webi and deski of XI R2 not the earlier versions
Can anybody tell me what are the tuning problems?