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
- 6432 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
what is universe null
What sort of existing documents should business analysts refer to when starting on a new project?
Explain how to schedule the report in b.o?
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!!!
Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.
what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?
CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN
What is the difference between datawarehousing and businessintelligence?
What is the difference between absolute and relative div positioning?
How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.
Explain what is aggregate table and aggregate fact table ... Any examples of both?
Difference between zabo and webi?
What is package in BO
Explain the data types present in bo and what happens if we implement view in the designer and report?
