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?






If you have 3 facts and 4 dimension and you need to join would you recommend joining fact with 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

Post New Answer




More OBIEE Interview Questions

How do you define the relationship between facts and dimensions in BMM layer?

1 Answers  


Can you use outer join in BMM layer?

1 Answers  


What is query repository tool?

1 Answers  


What is logging level? Where can you set logging levels?

1 Answers  


What is the end to end life cycle of OBIEE?

1 Answers  






What is aggregate navigation? How do you configure the Aggregate tables in OBIEE?

1 Answers  


Can you have multiple data sources in OBIEE?

1 Answers  


What is the difference between Data Level Security and Object Level Security?

1 Answers  


What is level based metrics?

1 Answers  


What are other ways of improving summary query reports other than Aggregate Navigation and Cache Management?

1 Answers  


How do you work in a multi user environment? What are the steps?

1 Answers  


 How to sort columns in rpd and web?

2 Answers  






Categories