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 are the different types of variables in obiee 11g? Explain
How do i disable cache for only 2 particular tables?
What are the different log files in obiee?
How will you execute direct sql in obiee?
What is Authentication? How many types of authentication do we have in OBIEE?
How do you know which report is hitting which table, either the fact table or the aggregate table?
How to get sql from obiee for reports?
Define repository in terms of OBIEE?
How to startup obiee in linux?
You come morning to the office. And all the users are complaining about the obiee reporting system is very slow(dasboards). What is your approach to resolve the issue?
what is guided navigation?
You worked on standalone or integrated system?