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 level based metrics?
How will effect the changes for a report , if for certain users only the column heading in the report should be changed?
Why do we have multiple LTS in BMM layer? What is the purpose?
What is scd type 1 and 2.
How online/offline mode impact development and delpoyment?
What are the different types of security you have worked in obiee?
What are global filter and how they differ from column filter?
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 object level security?
Do you know about Initialization Blocks? Can you give me an example where you used them?
If you want to limit the users by the certain region to access only certain data, what would you do?
How do you split a table in the rpd given the condition. ( the condition given was Broker and customer in the same table) Split Broker and customer.