How to create a Left Outer Join in FM? Please explain.

Answers were Sorted based on User's Feedback



How to create a Left Outer Join in FM? Please explain...

Answer / kumar

select 2 query subjects , then define the relationship 0-1
1-1 if that is between 2 Dimensions.
If that is between dimension, Fact 0-1 1-n {0-1(dimension),
1-n (fact )}

Is This Answer Correct ?    5 Yes 1 No

How to create a Left Outer Join in FM? Please explain...

Answer / shaan

Thanks Kumar.

One last query...

Can we edit the relationship in FM in the expression box?
Please excuse me as FM is not installed on my machine now
otherwise I could have checked it.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Cognos Interview Questions

What are the different kinds of panes included in cognos?

0 Answers  


What is meant by Reportstudio shortcut?

0 Answers  


Why cognos scenario is used?

0 Answers  


Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? Is it possible, if so how?

0 Answers  


-------What are the Adv of Star Schema and Snow Flake Schema?

4 Answers   Bank Of America,






All ready we have alias tables for modifications why we are using views if anybody this answer plz reply me

0 Answers   iFlex,


WHAT IS METRIC STUDIO?WHAT IS SCORE CARDS HOW TO IMPLEMENT IT AND WHAT IS THE USE OF SCORE CARD?

1 Answers   IBM,


How to apply securities for reports in cognos connection?

0 Answers   TCS,


difference between drill through and master detail report?

2 Answers   HCL, Zensar,


What is defined as catalog and types of catalogs in Cognos?

0 Answers  


If you have a report with list and cross tab in the same page. How do you restrict one user can see only the list and the other user can see both.

4 Answers   IBM,


What do you understand by the cognos?

0 Answers  


Categories