how to solve many -many relations ship in frame work
manager?and how to avoid cartigen product in frame work
manager?
Answers were Sorted based on User's Feedback
Answer / tanveer ahmed
To resolve the many - many relations, one has to broke
cardinalities of either tables... for example Student and
Teacher tables, you can clearly oberserves that One student
will have many Teachers and vice varsa one teacher can have
multiple students too....
so one must have broke the either cardinality of student or
teacher.... like example broke the table of Teacher into
two sub-tables and join the accordingly....
Please refer some good books for understanding how to
define bridge table first for this....
Thanks...............
Is This Answer Correct ? | 13 Yes | 1 No |
Answer / anik
generally many -many relationship comes when there is a
problem in your model . try to see if you are missing any
Query Subject which might have a relationship with both the
query subject which is creating many to many relationship .
for avoiding cross join too we have to specify the
correct relationship between the query subjects
Is This Answer Correct ? | 3 Yes | 1 No |
Answer / chiru
See if u look the above example of Student and teacher... Student is lower level... teacher is higher level... it is many to many to relations..so we cant join two table with different levels... so use determinants to avoid this ..
better click the below blog link u can get answer.........
cognosteacher.blogspot.com/
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / karna
if you dont know the answer.prepare it and let us know.
Is This Answer Correct ? | 3 Yes | 4 No |
Answer / jd
in framework manager there is a governor setting to disable
cross product joins. we have to make the option yes to
disable cross joins.
Is This Answer Correct ? | 4 Yes | 7 No |
Answer / ram
create relationships from the shortcut to other query
subjects.
Is This Answer Correct ? | 0 Yes | 3 No |
Answer / hemant
using determinants you can avoid many to many relationships.
Is This Answer Correct ? | 2 Yes | 8 No |
Answer / oooo
hi firest i am learning after iwill give anser
thanq to give oppertiunity
Is This Answer Correct ? | 2 Yes | 13 No |
What are the different kinds of panes included in cognos?
Hi all... how can we publish packages using bmp scripts to Path:Public Folder Packages Folder
how u create cubes in ur project
There are some reports,we have to provide security to that reports like the hr manager should have access to hr department reports only and the accountant should have access to accounts reports where as the CEO can have access to all the reports. How to deal with this situation using Cognos?
what is the different between primarykey and surrogated key.. why we are going for surrogatekey...
What do you mean by query studio?
actually my qus is i used some tables in my model,i published that to connection i use that one.at the same way my team member added some new tables and again he published how can i get my model in connection pls pls explain me..........
How security is concerned with Reportnet? Explain its implementing steps.
Difference between Express authoring mode and Professional authoring mode?
How to select all in value prompt instead of cascade prompt?
What is use of Field Set present in toolbox?
Hi, I got a requirement wehre in in a drill through report , in parent report i have a column of numbers on which i have to apply drill through to child report.The condition is in that column if the number ia not zero the drill through link should appear (i.e., 1 to 9) if its 0 or negative number link should not appear. How ? Help would be appreciated