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 / praveen

What kind of data(column) they need that not mentioned in
the question.

But, If they want data from both table we can use Join
comments by using primary key and forien key

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Its regarding Javascript coding for customization in BI4 reports. We need to have all the options disabled in the report except the option to Export(save the report in computer in Excel/pdf formats). I am able to hide TopBar,TabBar,Left Navigation etc but I need "Export" option to be displayed to the users in Read mode. Can this selective "hiding" be achieved?

1482


Explain how to execute the plsql procedure from the report by clicking with mouse?

602


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...

1726


Explain how many universes can be created in a project?

620


Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?

556






How to create Index to the table in the universe designer and how it improves the Query performence

2124


how to create reports on screech?

2080


Explain what would you consider as your biggest achievement and why?

578


Can any one say me how i can integrate 3 or more analytics like radio bottons,line chart,pie chart while designing a dash board in xcelsius and i am also facing problem to show one after another values in the same chat at a time..... Please help me out for this....

1492


What are the steps to be taken to schedule the report?

558


What is the difference between datawarehousing and businessintelligence?

622


What is report template in b.o?

588


What are the steps to do to use alerts in bo?

635


What is thumbnail?

582


I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.

3000