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?
Answer / madhu
Instead of joining fact with fact we can create one logical table (fact) and add the 3 fact tables as logical table source in the BMM layer.
|Is This Answer Correct ?||1 Yes||0 No|
How do you define the relationship between facts and dimensions in BMM layer?
Can you use outer join in BMM layer?
What is query repository tool?
What is logging level? Where can you set logging levels?
What is the end to end life cycle of OBIEE?
What is aggregate navigation? How do you configure the Aggregate tables in OBIEE?
Can you have multiple data sources in OBIEE?
What is the difference between Data Level Security and Object Level Security?
What is level based metrics?
What are other ways of improving summary query reports other than Aggregate Navigation and Cache Management?
How do you work in a multi user environment? What are the steps?
How to sort columns in rpd and web?