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 are the challenges you faced while making of reports?
How do you work in a multi user environment? What are the steps?
How analytics process your request when you create your requests?
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.
What is aggregate navigation? How do you configure the Aggregate tables in OBIEE?
What is the difference between Data Level Security and Object Level Security?
What is scd type 1 and 2.
How many bi services node can be clustered together?
You come morning to the office. And all the users are complaining about the obiee reporting system is very slow(dasboards). What is your approach to resolve the issue?
What are the different log files in obiee?
How do you identify what are the dimension tables and how do you decide them during the Business/Data modeling?
Suppose I have report which is running for about 3 minutes typically. What is the first step you take to improve the performance of the query?