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 |
1.How to convert deski document to webi in infoview? 2.what is connection type for free hand sql?
Hi,can anybody help me to do like this, i have one dp with agerange, first name ,Address. And another dp is agerange,age min , last name. in this two data providers agerange is common . I want to see in my report all the fields . How i can merge it ?
how to increase the perfomance in ur designer & reporting? how to reduce the refershing time & what precations would u take ?
I need to modify Web Intelligence Report, I need to Add 7 columns in WEBI Report-Java Pannel, so i could Add only 6 Columns in the Webi-Java Pannel as one X Table - X Column is not available in the Universe. I was advised that i can do it with Free Hand SQL in Web Intelligence even X Table - X Column is not available in Universe. Please kindly let me know how to implement the same
what r the types of joins universe supports
. User wants to modify a report and wants to add additional data. How will you approach.
Ihave one report.Now i want to display that report as one row as one color and another row as another color.The entire report i need like that
What is detailed Object
I have a report with some hyperlinks,any issue will i get when i migrate this report?
What is meant by Adhoc reports?Can any body will explain with examples...Thanks in Advance .........prakash
In a report i want to fetch teh data from 2 data Providers. which condetion wil satisfy to link the 2 data providers. ex: Q1 have columns A,B,C Q2 has a X,Y,Z columns. requirement is like i want to get all the columns from those 2 tables in report level..like A,B,C,X,Y,Z in a single report.
How many tables can an universe contain is their any limit to insert tables in the universe?