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 ?    2 Yes 0 No

Post New Answer




More OBIEE Interview Questions

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

1 Answers  


Can you use physical join in BMM layer?

1 Answers  


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?

1 Answers  


Why do we have multiple LTS in BMM layer? What is the purpose?

1 Answers  


If you want to limit the users by the certain region to access only certain data, what would you do?

1 Answers  






Can you use outer join in BMM layer?

1 Answers  


Define repository in terms of OBIEE?

1 Answers  


You worked on standalone or integrated system?

1 Answers  


How do you bring/relate the aggregate tables into the Siebel analytics Logical layer?

1 Answers  


How do you identify what are the dimension tables and how do you decide them during the Business/Data modeling?

1 Answers  


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?

1 Answers  


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?

1 Answers  






Categories