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
- 7895 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / rajesh kumar
select empid,name,depno from table1,table2 where
table1.deptno not in table2.deptno
| Is This Answer Correct ? | 5 Yes | 3 No |
Post New Answer View All Answers
Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?
How to schedule the report in b.o?
Explain how to execute the plsql procedure from the report by clicking with mouse?
Explain what sort of existing documents should business analysts refer to when starting on a new project?
Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...
1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?
(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.
Explain what is the difference between business requirement document and use case document.
Explain how many universes can be created in a project?
What sort of existing documents should business analysts refer to when starting on a new project?
how many reports have u created ? explain a few.
Migration of Reports from business objects 5.1.5 to samee version in different hardware?
Difference between zabo and webi?
Give some information on report bursting?
