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 ?||2 Yes||0 No|
Can you have multiple data sources in OBIEE?
What is data level security?
What is complex join, and where it is used?
What is the purpose of Alias Tables?
What is Authentication? How many types of authentication do we have in OBIEE?
What is aggregate navigation? How do you configure the Aggregate tables in OBIEE?
If there are 100 users accessing data, and you want to know the logging details of all the users, where can you find that?
You worked on standalone or integrated system?
How do you implement security using External Tables and LDAP?
Did you create any new logical column in BMM layer, how?
Can you use outer join in BMM layer?
If you want to limit the users by the certain region to access only certain data, what would you do?