what are the joins present in reportnet?which is most
widely used?

Answers were Sorted based on User's Feedback



what are the joins present in reportnet?which is most widely used?..

Answer / venkatesh

default join in F.M is inner join while creating the
relation ship between tables . u can change that by editing
the join.
Inner join is most widely used

Is This Answer Correct ?    4 Yes 2 No

what are the joins present in reportnet?which is most widely used?..

Answer / x

Generally we have two types of joins here. 1.Inner
join,2.outer join but widely we are using inner join.
Outer join is used for only when we need unmatched rows at
the time we will go outer joins.

Is This Answer Correct ?    1 Yes 0 No

what are the joins present in reportnet?which is most widely used?..

Answer / x

The joins present in the reportnet are innerjoin and outer
join. The most widely used join is inner join. Its a
default join

Is This Answer Correct ?    2 Yes 2 No

what are the joins present in reportnet?which is most widely used?..

Answer / buyile

as all have set inner join is the default joing in
Framework Manager , however by generating the native sql
from the report you can be able to manipulate the joins to
cater for your condition

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Cognos Interview Questions

Hi All, When user run the cognos report, that report output data must be download/available in EXCEL / CSV file.? (like... list report contain PL,PT,PN,RVEN, that excel/csv default download must be list columns PL,PT,PN,REVN) Thanks in Advance, LN.

2 Answers   IBM,


Define dimensions?

0 Answers  


Diff b/w Crossproduct and Outerjoin?

0 Answers   IBM, Mind Tree,


What is the difference between group and associare?

0 Answers  


Can we create a web page where the report directory and the output can be viewed directly across cognos connection?

2 Answers   TCS,






3.User1 doveloped some report,user2 modify the same report and user 3 also updates in that same report? how to identify that report will be modified or not?

1 Answers   IBM, Thomson Reuters,


What is snapshot thumbnail

3 Answers  


Please answer me the below questions, It's really urgent, and ur help would be appreciated. 1. What is looping in FM? How do u control it 2. How do u create IQDs in FM? Explain 3. What are the diff u noticed between Cognos 8.2 and Cognos 8.4 4. Can we use cube as a data source? How 5. How do u connect ur database in FM? do u connect directly 6. What's the structure of your database? Say u use Oracle 7. Did you use tables or views to bring the data from your DB 8. Does the dimensions of analysis studio have hierarchy? 9. Did you create any dashboards? How u created, explain

0 Answers  


Column level security in report

4 Answers  


What is the difference between drill down and drill through?

10 Answers   DELL, Deloitte, Systime,


what is cognos architechure

4 Answers   Cap Gemini,


How to connect three fact tables?

11 Answers   L&T, TCS,


Categories