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 ? | 2 Yes | 0 No |
What is a bridge table ?
Do you know about Initialization Blocks? Can you give me an example where you used them?
What are other ways of improving summary query reports other than Aggregate Navigation and Cache Management?
What are the different layers of obiee repository?
What are the major challenges you faced while creating the rpd?
What is level based metrics.how will you create it?
What are different types of joins that are possible in obiee rpd?
What is the difference between Data Level Security and Object Level Security?
How do you implement security using External Tables and LDAP?
What is a table alias in obiee? And where and how will you create it.
What is time series wizard? When and how do you use it?
What is clusterservices in obiee ? Why its used?