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

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

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/

Answer / karna

if you dont know the answer.prepare it and let us know.

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.

Answer / ram

create relationships from the shortcut to other query
subjects.

Answer / hemant

using determinants you can avoid many to many relationships.

Answer / oooo

hi firest i am learning after iwill give anser
thanq to give oppertiunity

What are all the components of Report Studio?

0 Answers  

where we use page break  and page set. with example?

1 Answers   CNSI, IBM,

Can we provide Package level security to two different groups i.e for finace and HR depts should access only their data??

2 Answers   Barclays,

how many types of keys are there i.e primary key and foreign key etc..?

2 Answers   IBM,

What is power prompts?Can somebody explain me.

2 Answers  

How to maintain Query subject’s relationships between Database layer and Model Layer? For eg - if 2 DB layer's query subjects are copied in Model Layer - Query subjects respectively, then Where should we define relationship of both Query subjects? Either in DB layer or Model layer?

0 Answers  

Sales person are there in one company How to do Bursting on this particular requirement?

0 Answers  

What is the difference between drill down and drill through?

10 Answers   DELL, Deloitte, Systime,

what is the difference between aggregation and roll up aggregation?

1 Answers  

What is Model Versioning or Versioning in Cognos Framework Manager?

2 Answers   Systime,

What is IQD?What is contained in IQD?

3 Answers   ABC, IBM, Infosys,

Write a SQL query which should fetch the 5th maximum salary of an employee from the table?

14 Answers   HCL,