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

How can I change reports to another package???

3 Answers   IBM,


1.Can we create a cube in a Transformer from multiple IQD's ?if so, how? 2.Also , explain some of the best practises used ,while creating a cube in powerplay transformer.

2 Answers   Satyam,


hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com

0 Answers  


What are cognos connection initial page components?

0 Answers  


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

1 Answers   IBM,


What is Fullouterjoin?

0 Answers  


how data modeling is usefull to cognos?

1 Answers  


what is a box type in cognos? what is a stitch query? what are the services that run in background when cognos is running

2 Answers   IBM,


6. Which of them will increase the performance?

1 Answers  


What are the advantages of using cognos sql?

0 Answers  


What is the difference between filter & Condition?

4 Answers   IBM, Polaris, TCS,


Hi Techies, I got an issue so need your advice here. I have created a report in Report Studio and it's having 2 columns which are having long text as a value (BLOB data type). Report is displaying entire text items in HTML format, but when I'm exporting it into EXCEL it's give me ##########. How to correct (wrap) it in Excel? so when end users they are directly running that report in Excel so instead of seeing ######### for long text items they should see the entire text items in those columns. Please advice!

5 Answers   HCL, Wipro,


Categories