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?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How we drill up week to month?

617


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?

552


Explain how to schedule the report in b.o?

561


Regarding Hyperlinking in Business Objects. We have a few reports in QA environment where a number of hyperlinks are employed using OpenDoc function.In some of the reports,hyperlink is used to move to another tab within the same report.The formula used include "DocID" and ReportName="tab name".This works fine but now,for the PROD move,this will not work as the Doc Ids are subject to change. Is there a way to overcome this?Without DocID,how will move to a particular tab? Thanks in advance

4440


I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!

1751






(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.

992


webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??

3915


Explain what is the difference between slice and dice and cross tab report?

605


What three things do you consider to be the most important factors for a manager?

591


U r project in which stage in implementation?

1948


how to create reports on screech?

2074


Did you face any problems while creating reports? Name? Solutions?

3256


Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?

629


How many universes can be created in a project?

597


Explain the data types present in bo and what happens if we implement view in the designer and report?

558