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

Q1. Why do we use determinant? Please explain with examples? Q2. What is new arrive dimensions? Please explain with examples? Q3. Suppose we have a table which is holding a large number of records. There are 4 columns which are very frequently used in the Cognos reports, so can we create indexing on those 4 columns?

2 Answers   Mphasis,

difference between imprompt and reportnwt1.1

2 Answers   HSBC,

how many notations are posible(cordinolity)are there in between two tables(one is fact and another is dimension)pls give me a example pls.

0 Answers  

My problem is as follows I made two pages of the portal; in the first page i have two reports and from one of these i would like to communicate in some way (i.e drill- through?) with the second page that contains four reports (prompt value [product] and three chart [sales revenue, sales quantity and budget]). Particularly I would like to communicate with the report that contains the prompt, passing the Product. How can i drill from the first page of the portal to the second page ? More generally, is it possible to move from one page, containing 2 report, to another page with 4 report, through a drill-through or any other mechanism? Thank in advance.

1 Answers  

how to access the database directly from cognos reportnet

2 Answers  

what is the difference between aggregation and roll up aggregation?

1 Answers  

2.How do you drill through report from Report Studio to Analysis studio?

3 Answers   IBM,

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

1 Answers  

3. What was the size of your cube?

1 Answers   IBM,

how u burst the reports? if u r bursted reports is not reached to destination how u identify???

2 Answers   Infosys, Wipro,

---------------What is meant by Scheduling?

2 Answers   IBM,

how to perform single sign in cognos by using url?

0 Answers   IBM,