Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 2 Answers
- 6640 Views
- Hexaware, I also Faced
- E-Mail Answers
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
Is there any other repository domains rather than universe, security, document?
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?
what is xcelsius architecture?
What is a fantrap in business objects?
Regarding Hyperlinking in Business Objects. We have a few reports in QA environment where a number of hyperlinks are employed using OpenDoc function.In some of the reports,hyperlink is used to move to another tab within the same report.The formula used include "DocID" and ReportName="tab name".This works fine but now,for the PROD move,this will not work as the Doc Ids are subject to change. Is there a way to overcome this?Without DocID,how will move to a particular tab? Thanks in advance
Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?
Can we Save (save as) WEBI Doc as DESKI?
How can you first report in Business Objects by using broadcast agent?
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?
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
Explain the difference between detect alias and detect context?
how to create metric universe ?
Explain what are the steps to do to use alerts in bo?
Difference between zabo and webi?
Explain what is aggregate table and aggregate fact table ... Any examples of both?
