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
Answers were Sorted based on User's Feedback
Answer / 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 |
Tell me about linked universe ?
4.what is aggregate awareness ? how do we use ? where do we use ?
BO Webi report in running fine in Dev but takes a long time to run in Production environment, how to reduce this processing time.
Hi any done business objects certification.i am expecting some help from them.
I have a situation like one manager can have multiple learners under him. each learner will registered for more than one certifications . their statuses for different courses like completed, inprogress, dropped, no certifications. the question is i have check for each user for statuses if he had some completed certifications i have to get latest completed date and omit all other stauses. if he had no complete staus then i have to get latest inprogress record based on date. like this i have to select only one record for user. but i am getting one row for each status. among all completion status one record, for all inprogress one record, for all dropped status one record. how can i show only one record
Can we add our own component in Xcelcius ,I am having a Indian client and I want to either create or import component (map) is it possible?? Currently I have imported Map image and working through icons is there any other way out??Please help.
normally we get many contexts when resolving loops or traps,how do u take them to reports.
Explain how to execute the plsql procedure from the report by clicking with mouse?
Migration of Reports from business objects 5.1.5 to samee version in different hardware?
hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message
What is the difference between the prompt and cascading prompt
5.what is LOV? where it is store?