Can you use outer join in BMM layer?






Can you use outer join in BMM layer?..

Answer / madhu

Yes we can. When we are doing complex join in BMM layer in the join properties we have an option to change the type of join to left outer, right outer, full outer or inner.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer




More OBIEE Interview Questions

What are the things you can do in the BMM layer?

1 Answers  


Why do we have multiple LTS in BMM layer? What is the purpose?

1 Answers  


What is the difference between Single Logical Table Source and Multiple Logical Table Sources?

1 Answers  


Did you create any new logical column in BMM layer, how?

1 Answers  


If there are 100 users accessing data, and you want to know the logging details of all the users, where can you find that?

1 Answers  






If you have 2 fact and you want to do report on one with quarter level and the other with month level how do you do that with just one time dimension?

1 Answers  


What is logging level? Where can you set logging levels?

1 Answers  


Can you migrate the presentation layer to a different server.

2 Answers  


You worked on standalone or integrated system?

1 Answers  


Can you use physical join in BMM layer?

1 Answers  


What is Authentication? How many types of authentication do we have in OBIEE?

1 Answers  


We have 4 dimension tables, in that 2 tables need to have hierarchies then in such a case is it mandatory to create hierarchies for all the dimension tables?

1 Answers  






Categories