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|
What is a bridge table ?
How to hide certain columns from a user?
What are global filter and how they differ from column filter?
How will you create interactive dashboards ?
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?
What is the difference between Data Level Security and Object Level Security?
What is clusterservices in obiee ? Why its used?
What is logging level? Where can you set logging levels?
How will you create report from two subject areas
Can you migrate the presentation layer to a different server.
what is guided navigation?
Explain the architecture of obiee and what each components do?