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|
What are the things you can do in the BMM layer?
Why do we have multiple LTS in BMM layer? What is the purpose?
What is the difference between Single Logical Table Source and Multiple Logical Table Sources?
Did you create any new logical column in BMM layer, how?
If there are 100 users accessing data, and you want to know the logging details of all the users, where can you find that?
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?
What is logging level? Where can you set logging levels?
Can you migrate the presentation layer to a different server.
You worked on standalone or integrated system?
Can you use physical join in BMM layer?
What is Authentication? How many types of authentication do we have in OBIEE?
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?