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

advantages of detailed filter??? and summarized filter???

4 Answers   iFlex,


actually 2 members working in same module.at a time is possible to work on same module? i add some tables,another person also add some tables how the synchronization betn the two in same module? pls ans me and expain to me.....

0 Answers  


Can you define cognos decision stream?

0 Answers  


What are the differences between cognos 8.2 and cognos 8.4? Please help me..

1 Answers  


what is the difference between group span and level span

1 Answers   Satyam,






What snowflake and Starschema?

2 Answers   HCL,


If you need latest cognos certification dumps to get certified in first attempt with 100% score, please e-mail to getmecert@yahoo.com

4 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  


What is an open session command in cognos connection?what is it meant for?

1 Answers   Infosys,


What are the types of security?

0 Answers  


What is the deployment requirements used in cognos?

0 Answers  


how to change the colour of the bar in charts...?

3 Answers   IBM,


Categories