Tow tables is there employee, projects .
(many to many) one employee has different projects and one
project has different employees . how we can achive the data
from both
Answer Posted / raja mahesh
Here a row in Employee table can have many matching rows in Projects table, and vice versa. You create such a relationship and can retrieve data by defining a third table, called a junction table, whose primary key consists of the foreign keys from both table employee table and projects table.
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
When to use local filter and when to use global filter?
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??
is it possible to export the webi reports to crystal reports?with out using businessview?
Explain what is the difference between slice and dice and cross tab report?
How we drill up week to month?
Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?
What is the functional & architectural differences between business objects and web intelligence reports?
in sap bi we have wad, then why we go for sap bo
Explain about a time when you discovered a more efficient way to do a work task?
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...
What are the steps to do to use alerts in bo?
U r project in which stage in implementation?
What is top business?
what are the day to day activities of BO administrator ?
Explain difference between zabo and webi?