Interested to Buy Any Domain ? << Click Here >> for more details...
how to solve many -many relations ship in frame work
manager?and how to avoid cartigen product in frame work
manager?
- 8 Answers
- 24213 Views
- HSBC, I also Faced
- E-Mail Answers
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 |
How can we do the unit testing?
1)How can we do the Union in Report Studio? 2)What is the meaning of Aggregation and Rollup Aggregation? 3)How can we hide the columns in Report Studio and How can we view the hiding Objects? 4)Can we provide joins in Report Studio and in which situation we can go for outer join? 5)If we take a Date Prompt and run it once it will show default data,how can we change it exact 1 month back data?
what is the diff. between a link n a union? what is a custom view? what is the use of unlocking a report ? plz answer to these
what is conditional query subject and example
Can you define drill down and drill up?
How do you schedule process automatically in cognos.I.e we have 50 reports and 100 users that will schedule daily, weekly, and monthly basis? Pls, give the answers the query early on.
What is Render Variable? where u can use?
how to do page breaks in cognos 8 Report studio pls give the navigation
Hi Techies..., can any one please answer me what is called unit testing ? how to do it and what are the steps involves in it? thanks for your answer......
What are the problems you have faced recently while developing reports in report studio? And how did you solve those problems? This question is asking in many interviews,,,,so pls help me,,,,,
What are the best practices while building a Cognos Framework Manager Package ? As in, what calculations would you not like to be handled in FM and rather get it directly from Database.
my report ended at the half of the last page but i don't want that matter in the last page I would like to adjust the matter in the previous page .how can i do this?
Teradata 
