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 is the size of the cube?

0 Answers  


Due Date (Highlight Issues in Blue where Due Dates are less than Todays Date),I have only Due Date column then how to over come the problem.How to find out which Due Date are less than Today Date...Kindly provide the detail steps to my mail ID-->asimcognos10@gmail.com

2 Answers   IBM,


What are shortcuts? Where it can be used? What are the advantages?

0 Answers  


Can u please describe the different types of traps with eg. Thanks

2 Answers  


hi, I want to create this report... List View--- -(Drop down list) Order Date From: \/ To: Customer Employee Order customer ------------------------------------------------------------ ------------------------------------------------------------ ------ customer c-name c-address c-phone c- city.................... ------------------------------------------------------------ ------------------------------------------------------------ ----- c-id c-type . . . ------------------------------------------------------------ ------------------------------------------------------------ ---- Employee .............same like one list Order.....................same like one list These are all in one page....i want u show... condtions *when i select in view type ex:employee and date as 10-05- 2007 to 10-05-2010 I need to go the employee list table and display the items .. And Iam trying in value prompt for creating of (cust,emp,ord)in a single value prompt,that will not created... and how to create 3-list and connection for those in value prompt.. Pls any one knows explain me (by step by step) of creating that report? Thanks Vannur

0 Answers  






What is the difference between filter & Condition?

3 Answers   MetLife, TCS,


where exactly determinants are used in cognos framework manager?

4 Answers   Satyam,


Actually we have 500 users when they run the report display the flage image related country user? How its possible?

0 Answers  


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

2 Answers   Cisco,


What is meant by drill down?

0 Answers  


how to add a new dimension in the powerplay transformer.i.e already we have devbeloped one cube. in that we want to add one new dimension cn anybody plese tell me the step by step procedure.

4 Answers  


In a Single page we are having 3 list. While running each has to populated in separate page?

2 Answers   TCS,


Categories