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 time series wizard? When and how do you use it?
What is the purpose of Alias Tables?
If you have 3 facts and 4 dimension and you need to join would you recommend joining fact with fact? If no than what is the option? Why you won’t join fact to fact?
How many bi services node can be clustered together?
Can you have multiple data sources in OBIEE?
Define repository in terms of OBIEE?
What are the different types of variables in obiee? Explain
How do you bring/relate the aggregate tables into the Siebel analytics Logical layer?
How will you enable or disable caching in the system level and table level?
How will you do different types of narrative reports in obiee?
Did you create any new logical column in BMM layer, how?
What is star schema and snowflake schema?