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
How we drill up week to month?
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?
Explain how to schedule the report in b.o?
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
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!!!
(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.
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??
Explain what is the difference between slice and dice and cross tab report?
What three things do you consider to be the most important factors for a manager?
U r project in which stage in implementation?
how to create reports on screech?
Did you face any problems while creating reports? Name? Solutions?
Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
How many universes can be created in a project?
Explain the data types present in bo and what happens if we implement view in the designer and report?