Interested to Buy Any Domain ? << Click Here >> for more details...
you have two tables table 1 contains emp id,name and deptno
and tble 2 contains only depatment number some of the
depatment no of 1st table are not present in table 2 how
will you create a report only to get the departments of
which excess in table 1
- 4 Answers
- 7891 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / taruna
The question is 'how to create a report' and not database query!!! We may apply MINUS operator between the two queries in query panel. This will give the difference.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
How to execute the plsql procedure from the report by clicking with mouse?
Explain what three things do you consider to be the most important factors for a manager?
What is top business?
Is there any other repository domains rather than universe, security, document?
Explain the difference between union and group?
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
Explain which versions are used in the bo dashboard work?
Can we Save (save as) WEBI Doc as DESKI?
Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?
BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...
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
explain in detail about type 3?
Explain what are the steps to be taken to schedule the report?
Explain the data types present in bo and what happens if we implement view in the designer and report?
What are the steps to do to use alerts in bo?
