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
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
Explain which versions are used in the bo dashboard work?
CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN
Migration of Reports from business objects 5.1.5 to samee version in different hardware?
Can more than 1 metric be applied on an analytic in business objects?
How to generate the report from excel sheet?
What are the steps to be taken to schedule the report?
What sort of existing documents should business analysts refer to when starting on a new project?
what are the tables used in health care domain project and columns used in report?
Can we create universe with no cache??
In banking domain how many Fact tables,Dimension table are present?
Is there any other repository domains rather than universe, security, document?
Explain in detail about type 1?
What is package in BO
How many universes can be created in a project?
Explain the difference between detect alias and detect context?