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

Hi Friends, Just want to know, day to day is increasing or decreasing Cognos Usage in the Market? New Reporting tools to driving Reporting Market Spotfire, Tableau,Qlick View, some other New Tools. Which Reporting tool can generate Lot of Opportinities in the Market? Please Reply to this, My Advanced Thank to you. Thank You Kumar

2 Answers  


hi guys, i think this would be a simple question but i was asked. what is total time taken to develop a report from getting requirement document from the client? dont reply as it depends,i am expecting something else.

2 Answers   WNS,


Explain about scorecarding?

0 Answers  


Hi Buddies... i want to appear for cognos BI-Author certification. can anyone of you send me cognos latest dump. please help me.. cognoslalitha@gmail.com

4 Answers  


Hi, I am Searching on Cognos 8, If any experienced person can send out a project or explain a realtime scenario that would be very helpful for me. Please be kind towards me and help me in this regard. I am really finding difficult to find a person who can guide me in this feild. Your help will be highly appriciated. My email id is balajishriram@gmail.com. Hope you will help....

3 Answers   Deloitte,


Hi Friends, Please tell me at What situations we use the Segment, Link in FM, What is the Main Difference functionality wise? Thank You

1 Answers  


How to improve the performance of the report at the report level?

3 Answers  


I need your kind support. I have more than 6yrs of exp in s/w industry. I have worked on some DW technologies which are out dated. For almost 1 year I was on bench.During this bench period I learnt cognos on my own using online docs. Hence I am alligned to a project few months ago to work on cognos. Unfortunately after joining this project I did not get opportunity to work on cognos. I am working on different things apart from cognos. I should get job in another company. Otherwise I am gone. I am confident enough to get job on Cognos in another company. Please let me know is it possible to work on Cognos at lead position (as my current position is at lead level) without having real time experience. Your response is highly appreciated and I will be grateful to you. Thanks in advance Ganesh

2 Answers  


im having null data in one of the cell in my report i have to display as "no data" when u run the report how can i achive this problem?

6 Answers   IBM,


Explain the different stages in creating a report in cognos report net?

3 Answers   IBM,


is there any difference between operational database and data base?if yes what r they?

0 Answers  


Can you define a catalog and types of catalogs in cognos?

0 Answers  


Categories